keep formatting in pivot

B

Bonnie

How do I keep the formatting for numbers in a pivot table after I have
refreshed it? I have already tried to do this by changing the "table option"
by unchecking the "auto formatting" and checking "perserve formatting", and
this didn't work. Can you someone please help?

Thanks!
 

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
Pivot Table Formatting 4
Dealing with a Pivot Table (when I don't want to) 0
Preserve Formatting for Pivot table cross 'Refresh Data !' 0
Table of content - format does not get saved 2
Word doc keeps changing to ALL CAPS 0
Power Pivot. Yikes. 0
How do I save Pivot Table Data 4

Top