Select the cell (assume it's A1) do datavalidation and allow custom and use
this formula

=MOD(100*A1,1)=0


--

Regards,

Peo Sjoblom

"Tim" wrote in message
...
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.