software

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

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

--
Additional information:
- I'm using Office XP
- I'm using Windows XP
Please don't multi-post. Your question has been answered already

--
Kind regards,

Niek Otten

quot;0-0 Wai Wai ^-^quot; gt; wrote in message ...
| Hi.
| I would like to extract the fraction part out of a number. For example:
| 1.5 -gt; 0.5
| 23.45 -gt; 0.45
| 25 -gt; 0
|
| Is there any simple way to do it?
| Thank you.
|
| --
| Additional information:
| - I'm using Office XP
| - I'm using Windows XP
|
|
Did I? Where?
It must be a mistake. Sorry!

PS: Later I found out the duplicate post in excel forum. Sorry about that.

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

quot;Niek Ottenquot; gt; ¦b¶l¥ó¤¤¼¶¼g...
gt; Please don't multi-post. Your question has been answered already
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;0-0 Wai Wai ^-^quot; gt; wrote in message
...
gt; | Hi.
gt; | I would like to extract the fraction part out of a number. For example:
gt; | 1.5 -gt; 0.5
gt; | 23.45 -gt; 0.45
gt; | 25 -gt; 0
gt; |
gt; | Is there any simple way to do it?
gt; | Thank you.
gt; |
gt; | --
gt; | Additional information:
gt; | - I'm using Office XP
gt; | - I'm using Windows XP
gt; |
gt; |
gt;
gt;
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

quot;Niek Ottenquot; gt; ¦b¶l¥ó¤¤¼¶¼g...
gt; Please don't multi-post. Your question has been answered already
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;0-0 Wai Wai ^-^quot; gt; wrote in message
...
gt; | Hi.
gt; | I would like to extract the fraction part out of a number. For example:
gt; | 1.5 -gt; 0.5
gt; | 23.45 -gt; 0.45
gt; | 25 -gt; 0
gt; |
gt; | Is there any simple way to do it?
gt; | Thank you.
gt; |
gt; | --
gt; | Additional information:
gt; | - I'm using Office XP
gt; | - I'm using Windows XP
gt; |
gt; |
gt;
gt;