Omitting whole numbers when formatting decimals

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

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
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top