You can do this with Data Validation on the Data menu. Open the
Data Validation box, choose Custom from the list, and use the
formula

=FIND(".",A1,1)=LEN(A1)-2

Change A1 to the appropriate cell reference.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



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