| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| How do I return dynamic lists? | Excel Worksheet Functions | |||
Linear Mode
