Tag Info

New answers tagged


If you are not sure what value the cell is going to have you are probably more suited to using a formula like this: =TEXT(A1*(10^(LEN(RIGHT(A1,LEN(A1)-FIND(".",A1))))),"00000000") LEN(RIGHT(A1,LEN(A1)-FIND(".",A1)))- Works out the difference between the position of the decimal place and the last digit 5.84 becomes 584 which will then become 00000584. ...

Top 50 recent answers are included