Display Digits

[gronji2004]

Hi,

Does anyone know if its possible for excel to do the following? EG:

9.9+0.1=10.0

Id like a cell to show the 0.0 instead of the 10.0.

Cheers,
Alex

 

[barry houdini]

I'm not sure your intent is clear from one example, do you mean that you want to show the remainder when divided by 10, e.g. if 6.6 + 7.1 should give the result 3.7 then perhaps try using MOD function like this:

=MOD(A1+B1,10)