number

[ericlch16]

A1= 7637.979999999

what is the formula i need to put so that in A2= 763.98 only.. dont want 7637.979999999
in the cell. is that possible?


I dont want to use formatting as the original value is still in the cell.

Pls advise

 

[mikerickson]

something like
=ROUND(A1,2) should work

 

[CWatts]

=round(a1,2)