Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limit cell size in Excel 2003

Status
Not open for further replies.
mojo1979

mojo1979

Technical User
Joined
Nov 17, 2003
Messages
138
Location
US
Hi,

I want to limit the amount of text someone can input into a cell to 255 characters. How is this possible?

Thanks in advance!

Steven
 
Sort by date Sort by votes
Check out Validation under the Data menu. Set the Allow Criteria so that the text length is to be less than or equal to 255.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bkoopers
  • Locked
  • Question Question
Problem with Excel pasting into filtered cells
Replies
1
Views
647
combo
combo
Swi
  • Locked
  • Question Question
Excel Webservice
Replies
2
Views
820
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
787
SkipVought
S
ladyck3
  • Locked
  • Question Question
Excel 365 - Auto-Populating a cell from date in the next cell.
Replies
9
Views
784
ladyck3
ladyck3
Kim296
  • Question Question
Need Genius Help - Finding multiple duplicates between columns - EXCEL
2
Replies
38
Views
3K
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top