B
BunnyHop
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.
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.