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 IamaSherpa 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
Nov 17, 2003
138
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

ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
243
ladyck3
ladyck3
BugZap13
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
4
Views
246
BugZap13
BugZap13
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
264
Andyri
Andyri
renigar
  • Question
Having trouble with Excel Lookup
Replies
5
Views
476
renigar
renigar
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
433
Bijugate
Bijugate

Part and Inventory Search

Sponsor

Back
Top