Thread: restrict user in excel to numbers below 100
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 1,311
Default restrict user in excel to numbers below 100
Look at Data-Validation. Whole Number, less than or equal to, 100

HTH,
Paul

"Caroline" wrote in message
...
How can you restrict a user from entering a value above 100 in a
spreadsheet?


Reply With QuoteReply With Quote