Hi,

you can use formula:
=A1-INT(A1)
if the number is in cell A1 to get number as 0,54 or
=(A1-INT(A1))*100
to get 54

Regards,
Nika Lampe

"joepose" je napisal:

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!