keep the pivot data format

G

Guest

Can I keep the data format when I refresh the pivot data? I don't like to use
data format function in pivot table, I used the short cut key to format the
data, but my format dispeared everytime when I refresh the pivot table.
 
D

Debra Dalgleish

Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned
off, click OK

To format the dates, right-click on a cell in the date field, and choose
Field settings
Click the Number button, and set your number formatting
Click OK twice.
 
G

Guest

I tried "Preserve Formatting is turned on, and AutoFormat is turned
off. And format the cell by right click the cell format, but the format
dispears once I refresh the pivot table.

Thanks, Holly
 

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

How do I save Pivot Table Data 4
Pivot Table - Changes 5
Pivot Table - Currency Format 1
date filter in a pivot table 1
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Run Macro when changing tabs 2
Pivot Table Refresh not working properly 1
Pivot Table date format 1

Top