Tech Support Forum banner
Cancel

Excel Values in fields

795 Views 1 Reply 2 Participants Last post by  yustr, 
G
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.
Save
Like
Status
Not open for further replies.
1 - 2 of 2 Posts
yustr
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:
Save
Like
1 - 2 of 2 Posts
Status
Not open for further replies.
Tech Support Forum
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Windows XP Support Windows 7 , Windows Vista Support Motherboards, Bios|UEFI & CPU Networking Support Laptop Support

Top Contributors this Month

View All
spunk.funk
SpywareDr
Gary R
Recommended Communities
Community avatar for SkyscraperCity
SkyscraperCity
1M+ members
Community avatar for AVS Forum
AVS Forum
1M+ members
Community avatar for Climbing
Climbing
NEW!
30+ members
Top