-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
every time i refresh pivot , the column formatted as percentages goes back to decimal? how to fix?
- Thread starter daveyc18
- Start date
Excel Facts
Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
ExcelToDAX
Active Member
- Joined
- Feb 9, 2023
- Messages
- 269
- Office Version
- 365
- Platform
- Windows
Did you right-click within the Pivot table and click Number Format? Formatting just the cells won't work because once the pivot table refreshes, it will go back to the OG formatting.
Upvote
0
Similar threads
- Question
- Replies
- 0
- Views
- 120
- Solved
- Replies
- 3
- Views
- 376
- Replies
- 1
- Views
- 551
