View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
0-0 Wai Wai ^-^
 
Posts: n/a
Default Take fraction out of the figure

Hi.
I would like to extract the fraction part out of a number. For example:
1.5 - 0.5
23.45 - 0.45
25 - 0

Is there any simple way to do it?
Thank you.

--
Additional information:
- I'm using Office XP
- I'm using Windows XP