On Mar 12, 2:10 pm, "CLR" wrote:
Probably either the first or the second cell is the result of a formula
giving the multiple decimal places and formatted to only show the
two.........

Vaya con Dios,
Chuck, CABGx3

wrote in message

ups.com...



first cell, the value: 61179.17
second cell, the value: 67083.97
third cell, formula subtracting first cell value from the second.
instead of 95.20, the result is actually 95.19999999999710
Whats up?- Hide quoted text -

- Show quoted text -

Thanks, but I tried that . . . so I re-entered the numbers by hand
with only the two decimal places, and still get the extra significant
figures when I format the result to show them.