Daft Pivot Tables Question......

[paulrockliffe]

How do I format a column so it shows percentages as percentage, or money as money. I know how to do it but how do I do it so that I'm explicitly applying the format to the column rather than it's cells?

I have a huge spreadsheet full of Pivots and it's all hooked off a number of .csv files via connections into the Data Model in Excel, works great, except that if I point all the connections to a different set of .csv files (identical contents, different numbers) to create a different cut of my analysis, it tends to remove the number formats from new rows.

Doing my head in if I'm honest, it's like you can do as much clever stuff to create something that'll dazzle your boss as you like, but Excel always finds a way to fk you by screwing the UI. Buggers.

Anyway, I've tried selecting the whole column and I've tried selecting the whole column in the Pivot table, neither avoids the issue.

Ta

[FunkyGibbon]

Take a look about 2/3rds way down this page:

https://www.contextures.com/excel-pivot-table-form...

Section called "How to preserve pivot table formatting"

HTH

[paulrockliffe]

Thanks, that's answered that question and the other question I just realised I needed to ask about why they keep changing the formatting of my headers.

So annoying that the normal way of applying the formatting doesn't automatically cover this off, I can't think anyone has ever refreshed their data hoping that it also turns all their percentages into decimals and removes the word-wrapping from the column headings!

Cheers