G
Guest
Anyone knows how I can format a cell to show decimals only. Not the whole
number. E.g. 4,56 should show 56
Regards,
Reidar
number. E.g. 4,56 should show 56
Regards,
Reidar
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Hi
Have a look at the MOD function. Something like
=MOD(4.56,1)
should do the trick.
Have a look at the MOD function. Something like
=MOD(4.56,1)
should do the trick.
G
Guest
Hi,
It rbought me half way. The result in the cell shows 0.56 but I want to se
only the decimals 56
Any idea?
Regards,
Reidar
It rbought me half way. The result in the cell shows 0.56 but I want to se
only the decimals 56
Any idea?
Regards,
Reidar
A
Anne Troy
Use the MOD, then format the cell with a custom format of: .00
Hope it helps!
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
Hope it helps!
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
G
Guest
Hi,
Getting closer. I now get a "comma" in fron of the number like this ,56
How to get rid of the comma?
Reidar
Getting closer. I now get a "comma" in fron of the number like this ,56
How to get rid of the comma?
Reidar
A
Anne Troy
If you don't want the decimal, then just change the formula to:
=MOD(A1,1)*100
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
=MOD(A1,1)*100
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
G
Guest
Hi,
Solved it with a =right(fixed(n),2)
Reidar
Solved it with a =right(fixed(n),2)
Reidar
C
CLR
One way.........
=A1-INT(A1)
Vaya con Dios,
Chuck, CABGx3
=A1-INT(A1)
Vaya con Dios,
Chuck, CABGx3