How can I get the digits left and/or right of the decimal point in a formula?

[jamorin]

Let's say I have a number such as 123.456 and I want to use 123 in one calculation and .456 in another. Is there a command that allows this?

I've tried to use =Left and =Right without much success since these are text commands. I just cannot figure out the corresponding number functions.

Thanks as always

 

[Tom Urtis]

take a number ie. 123.456 and show the whole numbers (123) in one cell and the decimal number (.456) in another cell, assuming said number is in cell A1.

In the cell you want the whole number value use:
=INT(A1)

for the mantissa part use:
=MOD(A1,1)

 

[jamorin]

Tom thanks!

While searching I also found the function =TRUNC which I found helpful as well in another area of the spreadhseet. Again thanks so much.