Posted to microsoft.public.excel.misc

[email protected] is@bernuli.com is offline

external usenet poster

Posts: 2

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste error	Alan[_9_]	Excel Discussion (Misc queries)	0	December 17th 07 04:43 PM
Copy/Paste error	Anthony	Excel Worksheet Functions	2	February 7th 07 06:46 PM
Paste error from Query	GrahamV	Excel Discussion (Misc queries)	0	February 2nd 07 11:47 AM
Paste value error	PJG	Excel Discussion (Misc queries)	1	November 24th 06 02:07 PM
ActiveSheet.Paste - Error help?	dk_	Excel Discussion (Misc queries)	4	November 20th 06 12:27 AM

All times are GMT +1. The time now is 06:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us