plus, if you wish to allow for negative numbers:

=IF(A1<0,A1+(INT(A1)*-1)-1,A1-INT(A1))

or

=IF(A1<0,MOD(A1,-1),MOD(A1,1))


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