Data Validation-Allow Decimal

[howard]

I want force a user to enter a value with 2 decimal places

I have tried to use Data Validation -Setting Decimal and then under minimum have used 2 and under maximum have used 2 again, but when I enter a number for eg 148.25, it comes up with invalid entry

It would be appreciated if someone could assist me

 

[venkat1926]

"Setting Decimal and then under minimum have used 2 and under maximum have used 2"

that prarameter for the number you want to enter. instead between choose "greater than" and type 0

click ok

only point if user enters 1.256 it will be accepted. In such a case format it for 2 decimal places.

will this solve your problem

 

[mikerickson]

You could use the formula =INT(A1*100)=(A1*100).
The user could enter 34 or 1.2 or -1.23 but it would flag 3.14159 or CATS

 

[Armando Montes]

Try Custom: =ROUND(A1,2)=A1
Format cell as #.00

 

[howard]

Hi Venkat

Thanks for the help.

How does the Data Validation, Decimals work where one uses the option "between" and sets the minimum & Maximum?

 

[howard]

Hi Guys

Thanks for all the help, much appreciated