For 2.833, =A1-ROUND(A1,0) yields -0.167 and =MOD(A1,ROUND(A1,0)) yields
2.833. Instead of using round, I think you intended to use rounddown or Int.


I think a simpler approach would be =Mod(A1,1)


"Tevuna" wrote:

Every simple problem has a multitude of solutions. Here are two
=A1-ROUND(A1,0)
=MOD(A1,ROUND(A1,0))

"Crackles McFarly" wrote:

Say I have a list of cells with numbers, some even some odd and some
with trailing decimals like so.
2
2.33
2.833
2.99
3
3.5
4
4.22

How can I get rid of the WHOLE number ? I need to manipulate the part
that is not the whole number.
thnx