View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
 
Posts: 207
Default 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