You have been given some good replies but please note if A1 = -1.56 then
=A1-TRUNC(A1) gives -0.56 (negative)
but
=A1-INT(A1) gives 0.46 (positive)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"joepose" wrote in message
...
Hello,
I have a requirement to ignore the whole number in a sum and just use the
decimals. To be more specific if I can get 6.54 lengths of metal from a
bar
length of 4000mm what size is the offcut?
I can find lots of info on ignoring the decimal but none on ignoring the
whole number.
Any help appreciated!