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.
|