Forum Discussion
Excel setting rule for digit count with decimal numbers
Hi there, Need to set a rule for data input (in certain column) that only 11 digits with 2 decimal places are allowed to be entered. Have certain data to prepare for input for another database wit...
Hi Ilze,
The rule for number of decimal places could be
=(IF(INT(A1)=A1,0,LEN(A1)-SEARCH(".",A1))=2)
you may combine it with total 11 digits length