Paste Value Error

[is]

I have a simple formula which evaluates to 4.3. If I copy the formula and
paste as value, the value I get is "4.29999999999995".

For example:
Finding the difference of 999(A1) and 994.7(B1) with "=B1-A1" the value
returned is 4.3. Put if you copy the formula and paste special as value only
you get the 4.2999 number.

Noticed this when breaking links in a document and it is now driving me crazy.

 

[Paul]

It's not so much a "paste value error" as "the way Excel does math".
The following site provides some information on why this occurs:

'Rounding And Precision In Excel
(http://www.cpearson.com/excel/rounding.htm)




I have a simple formula which evaluates to 4.3. If I copy the formul
and

paste as value, the value I get is "4.29999999999995".

For example:
Finding the difference of 999(A1) and 994.7(B1) with "=B1-A1" th value
returned is 4.3. Put if you copy the formula and paste special as valu only
you get the 4.2999 number.

Noticed this when breaking links in a document and it is now driving m

crazy.