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.

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)





is@bernuli.com;690134 Wrote: 
> 
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

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192877

http://www.thecodecage.com/forumz