View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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