Custom type with a formula of

=IF(ISNUMBER(G1),IF(NOT(ISNUMBER(FIND(".",G1))),TR UE,IF(LEN(G1)-FIND(".",G1)<3,TRUE)))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Darren L" wrote in message
...
Is it possible to restrict data entry to numercial values to 2 decimal
places
- perhaps using data validation?