View Single Post
  #1   Report Post  
Tim
 
Posts: n/a
Default Limiting Validation entries to 2 places after a decimal

I have a multi-user spreadsheet to enter dollar values. How can I limit a
user from entering, for example, 43.703 when the correct entry is 43.70?

I can do this by changing the number format but do not want to do that.