View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Getting numbers on the right side of the decimal point

If none of the suggestions work for you, you may want to explain what you want
when the original number is:

6.5

Do you want 5, 50, 500, ...



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


--

Dave Peterson