View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] is@bernuli.com is offline
external usenet poster
 
Posts: 2
Default Paste Value Error

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.