restrict user in excel to numbers below 100

  • Thread starter Thread starter Caroline
  • Start date Start date
C

Caroline

How can you restrict a user from entering a value above 100 in a spreadsheet?
 
Look at Data-Validation. Whole Number, less than or equal to, 100

HTH,
Paul
 
PCLIVE said:
Look at Data-Validation. Whole Number, less than or equal to, 100
Click to expand...
....

Note that data validation is easily defeated. Copy the text 123456 in,
say, this newsgroup post, switch to Excel, and paste it into a cell
with this data validation rule. Excel will accept it without
complaint. For cleverer users, there's no way to prevent changing
formula values, e.g.,

=10+(NOW()>--"2008-02-25 13:02")*1e300

Excel's data validation is weak. It can be dangerous to rely on it
exclusively. It's almost always better for formulas that use any user
entries to check those entries for validity, and return errors when
user entries are invalid.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on percentages greater than 100 3
Date and User restriction coding 1
Data validation - restrict duplicate value 8
Omit empty cells? 0
drag formula down from columns that go acros 3
Restricting Cell entry to certain letters 7
How do I restrict any one not to scroll more than 100 row? 1
Data Validation - restricted entry 3

Back
Top