Data Validation Syntax Question
 

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

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 wrote:

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

Thanks a million!

"Dave Peterson" wrote in message...
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 wrote:

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.