D Darren L Jun 6, 2008 #1 Is it possible to restrict data entry to numercial values to 2 decimal places - perhaps using data validation?
Is it possible to restrict data entry to numercial values to 2 decimal places - perhaps using data validation?
B Bob Phillips Jun 6, 2008 #2 Custom type with a formula of =IF(ISNUMBER(G1),IF(NOT(ISNUMBER(FIND(".",G1))),TRUE,IF(LEN(G1)-FIND(".",G1)<3,TRUE))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Custom type with a formula of =IF(ISNUMBER(G1),IF(NOT(ISNUMBER(FIND(".",G1))),TRUE,IF(LEN(G1)-FIND(".",G1)<3,TRUE))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
D Darren L Jun 6, 2008 #3 Superb. But I need to restrict data entry to only numercial values greater than zero to 2 decimal places - I can't seem to amend the formula to do this.
Superb. But I need to restrict data entry to only numercial values greater than zero to 2 decimal places - I can't seem to amend the formula to do this.
B Bob Phillips Jun 6, 2008 #4 =IF(ISNUMBER(G1),IF(G1>0,IF(NOT(ISNUMBER(FIND(".",G1))),TRUE,IF(LEN(G1)-FIND(".",G1)<3,TRUE)))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
=IF(ISNUMBER(G1),IF(G1>0,IF(NOT(ISNUMBER(FIND(".",G1))),TRUE,IF(LEN(G1)-FIND(".",G1)<3,TRUE)))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
D Darren L Jun 6, 2008 #5 Genius - works perfectly. Thanks very much Bob Phillips said: =IF(ISNUMBER(G1),IF(G1>0,IF(NOT(ISNUMBER(FIND(".",G1))),TRUE,IF(LEN(G1)-FIND(".",G1)<3,TRUE)))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Click to expand...
Genius - works perfectly. Thanks very much Bob Phillips said: =IF(ISNUMBER(G1),IF(G1>0,IF(NOT(ISNUMBER(FIND(".",G1))),TRUE,IF(LEN(G1)-FIND(".",G1)<3,TRUE)))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Click to expand...
