Omitting whole numbers when formatting decimals

[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.

 

[Jacob Skaria]

Try
=A1-INT(A1)
(and custom format it to .0000)

OR use the below formula to display this as
=TEXT(A1-INT(A1),".0000")

If this post helps click Yes

 

[Shane Devenshire]

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.