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