Forum Discussion
Ilze Vilka
Feb 11, 2018Copper Contributor
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...
SergeiBaklan
Feb 11, 2018Diamond Contributor
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