View Single Post
  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default Limiting Validation entries to 2 places after a decimal

One way:

Assume the validation is to be applied to cell A1:

Allow: Custom
Formula: =ABS(A1-ROUND(A1,2))<1E-8

In article ,
Tim wrote:

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.