custom data validation formula to limit cell value to maximum of 4 decimal places

[wotadude]

I require a custom data validation formula to limit cell value to maximum of 4 decimal places.

0.0001 ok
0.02 ok
0.3 ok

0.12345 fail
0.123456 fail etc

[dominicb]

Good evening wotadude

I require a custom data validation formula to limit cell value to maximum of 4 decimal places.

There are other ways of doing this other than using Data Validation, but seeing as you asked :

Allow : Custom
Formula : =A1=INT(A1*10000)/10000

should do the trick.
(Obviously, replace A1 with the cell you are starting with).

HTH

DominicB

[wotadude]

Thanks, does the job nicely.