Excel 2003/2007 paste special values shows bizarre results
Sorry...missed a step.
Select the entire rangeright clickFormat Cellsselect 'Number' in the
listset to 2 decimal places.
"Gaurav" wrote in message
...
I guess its just the formatting issue. Select the entire rangeright
clickselect number in the listset to 2 decimal places.
that should do it.
"TeeDub" wrote in message
...
I figured I had better give a specific example (or two)
592.58-591.57=1.01 -- paste special = 1.0099999999999999
115.53-114.79=0.74 -- paste special = 0.7399999999999995
|