pasting into pivot tables query

P

paul perkins IOM

i have several users, who since upgrading to Excel 2003, have an issue with
pasting values into a pivot table.

their data always defaults to date format, when they are trying to update
numeric values.

they can alter the cells format and all is well, but the changes arent
carried through to next time they use the worksheet/pivot

any ideas

thanks
paul
 

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

Top