Getting numbers on the right side of the decimal point
=RIGHT(A1,LEN(A1)-FIND(".",A1))
It is now 'text', but will keep any preceding zeroes (i.e.: 3.057 = 057) and
will avoid the bad rounding that otherwise might occur.
--
John C
"Tigerxxx" wrote:
What formula can I use to get the numbers on the right side of the decimal?
i.e. for a number 6.25, the result of the formula should be 25.
Thank you
|