 # Return Decimal Portion Of Number

• trunc gives just the numbers before the decimal point.
how do i get the numbers after the point.
original number minus trunc seems messy!

• Re: After The Decimal Point

=Mod(A1,1). This doesn't work for negative numbers, though.

• Re: After The Decimal Point

=right(a1,len(a1)-find(".",a1))

• Re: After The Decimal Point

For Sicarii's method, I would suggest putting +0 or *1 at the end to convert it to a number; otherwise, Excel reads it as text and formulas won't work.

• Re: Return Decimal Portion Of Number

A1-TRUNC(a1)

Quote from anon125;424254

trunc gives just the numbers before the decimal point.
How do i get the numbers after the point.
Original number minus trunc seems messy!

• Re: Return Decimal Portion Of Number

Quote from kof1979;604829

A1-TRUNC(a1)

thanks - easy - when you know how!

• Re: Return Decimal Portion Of Number

thanks!!

• Re: Return Decimal Portion Of Number

Quote from Armando Montes;604905

One more: =MOD(A1,1)

Sorry Armando but this will not work correctly for negative numbers. The only thing I've found that does work is A1-TRUNC(A1)

It's easy to run a check:

1) Cell C54 contains 10.298
C54-TRUNC(C54) yields 0.298
MOD(C54,1) yields 0.298

2) Cell C54 contains -10.298
C54-TRUNC(C54) yields 0.298
MOD(C54,1) yields 0.702

• Re: Return Decimal Portion Of Number

Quote from Armando Montes;628799

=MOD(ABS(C54),1)

thanks very much

• Re: Return Decimal Portion Of Number

Quote from Armando Montes;628799

=MOD(ABS(C54),1)

Yes, indeed, that works fine! Thank you, Armando.

I'm surprised, actually, that Excel doesn't seem to have a function that returns the mantissa. It has all sorts of similar functions (round, trunc, int, mod) - but not this one.

If anyone knows otherwise, please let me know!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!