how to remove label formatting (eg label to number)

S

sikkiekaka

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Embed the same Excel multiple times 0
Paste to excel from word - auto format problem 1
VB Script reference cells for in current table? 1
Linking data in MS Word into Excel 5
SUM & OFFSET & PIVOT TABLE?? 0
Time Sum in Excel 1
Get Pivot data not reading some cells 0

Top