"MartinW" wrote in message
...
Hi joepose,

Have a look at the TRUNC and INT functions in help.

With 6.54 in A1
=A1-TRUNC(A1) will equal 0.54
=A1-INT(A1) will equal 0.54

As will MOD(A1,1)
--
David Biddulph