Hi,

As mentioned by another user, this is because of Excel's floating point
number algorithm. You may read more on this on the MSDN blog:

http://blogs.msdn.com/excel/archive/...g-answers.aspx

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

"TeeDub" wrote in message
...
When I subtract a set of numbers, then take the result and paste
special -
values, often my results show a bizarre number of decimal places.

The cell shows the correct value, but the formula bar shows the oddball
numbers.
(Apparently it is using the imsub function to grab the value instead of
the
sub function.) This is causing havoc with a few comparison calculations I
am
trying to do within the worksheet.

Any suggestions on how to fix this?