View Single Post
  #2   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

You can use the following MOD function to return the remainder after dividing
the value by 1. The example assumes that the value to be divided is in cell
A1, change formula based upon your layout:

=MOD(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