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

Anyway I posted the answer here so to make the thread complete.

=MOD(A1,1)

Thanks for your help.

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

"Niek Otten" ¦b¶l¥ó
¤¤¼¶¼g...
Please don't multi-post. Your question has been answered already

--
Kind regards,

Niek Otten

"0-0 Wai Wai ^-^" wrote in message

...
| 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
|
|