Data Validation Syntax Question

[Jim & Gail]

I'd like to restrict a user (me) from entering more than two digits after
the decimal point in a cell. I have a checkbook spreadsheet and recently
discovered (by accident) that I made a withdrawal entry of 117.122 a couple
of years ago, but I can't figure out how to be sure to keep from doing it
again. Am I missing something simple?

Thanks for any help.

Jim

 

[Dave Peterson]

One way:
=INT(A1*100)=(A1*100)
multiply by 100 and see if it's a whole number
If A1 is the activecell.

Another way:
=MOD(A1*100,1)=0
multiply by 100 and divide by 1. Check the remainder to see if it's 0.

 

[Jim & Gail]

Thanks a million!

"Dave Peterson" wrote in message...