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!

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

Limit characters in Excel column 1

Status
Not open for further replies.

Delano29

Technical User
Jul 10, 2001
28
US
Hi, I am using Excel 2003. Is there a way to limit the amout of characters that you could put in an excel spreadsheet column? For instance, if entering alpha numeric information in column H I don't want the user to enter more than a three character reponse for that column.

I couldn't find any options in Excel that would do this.

Any help would be appreciated.

Thanks.
 




Hi,

Take a look at Data > Validation

Skip,
[sub]
[glasses] [red][/red]
[tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top