Tech Support banner

Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
44 Posts
Discussion Starter #1
I need help to know weather you can or can't set value to fields in excel. Ex: a field being 4 character exactly. If you can how would you do it? please and thank you.
 

·
Vetustior Humo
Joined
·
11,129 Posts
Sure...

Go to the cell to format>data>Validation>Settings>Text Length

Excel will alert on any entry not between the min and max you set. You can even write your own error message..."hey you pea-brain its got to be 4 characters..." or something nice like that... :1angel:
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top