|
return decimals only
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 |
|
Hi
Have a look at the MOD function. Something like =MOD(4.56,1) should do the trick. -- Andy. "Reidar" wrote in message ... 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 |
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 "Andy B" wrote: Hi Have a look at the MOD function. Something like =MOD(4.56,1) should do the trick. -- Andy. "Reidar" wrote in message ... 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 |
Use the MOD, then format the cell with a custom format of: .00
Hope it helps! ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Reidar" wrote in message ... 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 "Andy B" wrote: Hi Have a look at the MOD function. Something like =MOD(4.56,1) should do the trick. -- Andy. "Reidar" wrote in message ... 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 |
Hi,
Getting closer. I now get a "comma" in fron of the number like this ,56 How to get rid of the comma? Reidar "Anne Troy" wrote: Use the MOD, then format the cell with a custom format of: .00 Hope it helps! ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Reidar" wrote in message ... 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 "Andy B" wrote: Hi Have a look at the MOD function. Something like =MOD(4.56,1) should do the trick. -- Andy. "Reidar" wrote in message ... 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 |
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 "Reidar" wrote in message ... Hi, Getting closer. I now get a "comma" in fron of the number like this ,56 How to get rid of the comma? Reidar "Anne Troy" wrote: Use the MOD, then format the cell with a custom format of: .00 Hope it helps! ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Reidar" wrote in message ... 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 "Andy B" wrote: Hi Have a look at the MOD function. Something like =MOD(4.56,1) should do the trick. -- Andy. "Reidar" wrote in message ... 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 |
Hi,
Solved it with a =right(fixed(n),2) Reidar "Reidar" wrote: Hi, Getting closer. I now get a "comma" in fron of the number like this ,56 How to get rid of the comma? Reidar "Anne Troy" wrote: Use the MOD, then format the cell with a custom format of: .00 Hope it helps! ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Reidar" wrote in message ... 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 "Andy B" wrote: Hi Have a look at the MOD function. Something like =MOD(4.56,1) should do the trick. -- Andy. "Reidar" wrote in message ... 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 |
One way.........
=A1-INT(A1) Vaya con Dios, Chuck, CABGx3 "Reidar" wrote in message ... 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 |
| All times are GMT +1. The time now is 02:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com