View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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