Re: Take the fraction part out of the number

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

=MOD(A1,1)

--
Kind regards,

Niek Otten

"0-0 Wai Wai ^-^" <x@xxxxx> wrote in message news:%23GTgfVqZGHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
|
|
| 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
|
| ¥»¤Hªº¯à¤O«D±`¦³­­. ¦p¦³¤£·í¤§³B, ±æÃѪ̤£§[½ç¥¿!!
| After all, the above are merely my little opinion/idea.
| Since my ability is limited, I could be wrong.
|
|


.

Relevant Pages