Pivot Table Grouped Quarters Data Format (Qtr1> 01)

G

G12

Board Regular
Joined
Nov 11, 2008
Messages
113
Office Version
  1. 365
Platform
  1. Windows
Hi.
This feels like it should be an easy answer, but for the life of me I can't find it. I've a pivot table where the dates are all correctly grouped into quarters & years. However, I want to change the format of the entry for quarters from Qtr1 to 01. This would make the field heading Quarter and the results 01>04 depending on which quarter it was.

Can this be achieved?
Thanks
G12
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
You must log in or register to reply here.

Similar threads

D
  • Question
Conditional formatting on pivot table headers
Replies
0
Views
108
D_SQUARED
D
F
  • Question
Pivot table split into years and quarters
Replies
0
Views
328
flammabubble
F
A
  • Question
How to convert quarterly data to monthly data if I only have quarterly?
Replies
1
Views
3K
etaf
etaf
S
  • Question
Try to beat the limitations of Pivot Tables
Replies
3
Views
296
RoryA
RoryA
M
  • Question
Formatting Finance Tables in Excel for Mac - need advice!
Replies
0
Views
109
meitaliii
M

Forum statistics

Threads
1,214,520
Messages
6,120,003
Members
448,935
Latest member
ijat

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top