Data Validation to restrict user to input number with 2 decimal places only

[irfananeeza]

Hello Experts,

How can I use data validation in excel 2010 to restrict user to input number with 2 decimal places only?

Thanks,

 

[par60056]

How are they inputing the value? In a cell, an inputbox in a macro?

Without more information, all I can suggest is in a general way, test to see it value=floor(value,.01)

 

[TerryHogarth21]

Hello Experts,

How can I use data validation in excel 2010 to restrict user to input number with 2 decimal places only?

Thanks,

In Data Validation -> allow custom and input formula
=OR(IF(ISERROR(FIND(".",$A1)),LEN($A1)>0,LEN(MID($A1,FIND(".",$A1)+1,25))<3))

In this case I'm assuming that if a user types in a whole number it would be ok in your case. Just format the cell to 2 decimals.