ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Paste Value Error (https://www.excelbanter.com/excel-discussion-misc-queries/260645-paste-value-error.html)

[email protected]

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.



All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com