i am pasting pivot table data into a spreadsheet and need to remove the label
format of the pasted cells so other formulae can calculate results from the
pivot table.

NB in 98 copy and paste special values works but does not in xp