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