Hi,

Thanks. That worked but I still get a 0. Know of anyway to avoid that also?


"Joel" wrote:

use the MOD function with the mod parameter equal 1

=MOD(A1,1)



"BunnyHop" wrote:

Hi,
I am trying to omit the whole number when it is copied into a new cell.

Ex. 29.8765 = .8765

I do not want a leading 0 either or for the decimal to be rounded up or
down, but copy exactly the last four digits behind and including the decimal
point.

I also would like to nest this formatting in a formula that combines copying
the number from the old cell to the new and then automatically format.

Any help would be appreciated.

Thanks,