=MOD(A1,1)

--
Regards,

Peo Sjoblom

(No private emails please)


"swwong" wrote in
message ...

I mean 1.23 return to 0.23 or 2.12 return to 0.12. or 10000.1 return to
0.1


Thanks


--
swwong
------------------------------------------------------------------------
swwong's Profile:
http://www.excelforum.com/member.php...o&userid=23963
View this thread: http://www.excelforum.com/showthread...hreadid=375861