Digits to the right of decimal point
On the other hand, if you always have 3 digits to the right of the decimal
you could use =RIGHT(A1,3).
If there aren't fixed decimals, the following would work:
=RIGHT(A1,LEN(A1)-(FIND(".",A1,1)))
--
Kevin Backmann
"Tigerxxx" wrote:
Hello,
What forumla should I use to get the digits to the right side of the decimal?
i.e. if the number is 94.203, then I want to get the "203".
Thank you
|