return decimals only

[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

 

[Guest]

Hi

Have a look at the MOD function. Something like
=MOD(4.56,1)
should do the trick.

 

[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

 

[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

 

[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

 

[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

 

[Guest]

Hi,

Solved it with a =right(fixed(n),2)


Reidar

 

[CLR]

One way.........

=A1-INT(A1)

Vaya con Dios,
Chuck, CABGx3