Hi,

Suppose you copy it to B1 then in C1 enter
=MOD(B1,1)
and apply the custom format
..#####

keep as many # as you could have digits to the right of the decimal.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"BunnyHop" wrote:

Hi,

I am trying to copy a number, e.g. 24.8795 to a different cell. Once copied
I want to be able to format the new cell without the whole number(including
any 0)like .8795. I would like the number to remain a 4 decimal number and
not round up or down. I read a couple of suggestions on the forum but kept
coming up with the 0 in front.
Is there any way to make this work out? Also, I was trying to nest the two
functions together - copy into the new cell and then automatically have the
formatting done - so any help on that would also be appreciated.

Thank anyone in advance if they can give me some guidance.