Is there a way I can make absolutely sure that a user inserts a number value and not a letter or x as a check mark in a cell? (Microsoft excel 2007)
I noticed that if a user inserts a letter for example it will screw up the sheets and formulas won't work.
Thanks for the help.
Use Data Validation
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks