trunc gives just the numbers before the decimal point.
how do i get the numbers after the point.
original number minus trunc seems messy!
Return Decimal Portion Of Number



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
A1TRUNC(a1)
Quote from anon125;424254trunc 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;604829A1TRUNC(a1)
thanks  easy  when you know how! 
Re: Return Decimal Portion Of Number
One more: =MOD(A1,1)

Re: Return Decimal Portion Of Number
thanks!!

Re: Return Decimal Portion Of Number
Quote from Armando Montes;604905One 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 A1TRUNC(A1)
It's easy to run a check:1) Cell C54 contains 10.298
C54TRUNC(C54) yields 0.298
MOD(C54,1) yields 0.2982) Cell C54 contains 10.298
C54TRUNC(C54) yields 0.298
MOD(C54,1) yields 0.702 
Re: Return Decimal Portion Of Number
You might add ABS:
=MOD(ABS(C54),1) 

Re: Return Decimal Portion Of Number
Quote from Armando Montes;628799You might add ABS:
=MOD(ABS(C54),1)thanks very much

Re: Return Decimal Portion Of Number
Quote from Armando Montes;628799You might add ABS:
=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!