Home

Date Field Ungrouping from Years and Quarter in a Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-185352%22%20slang%3D%22en-US%22%3EDate%20Field%20Ungrouping%20from%20Years%20and%20Quarter%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185352%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%20I'm%20working%20in%20a%20pivot%20table%20and%20whenever%20I%20add%20a%20date%20field%20it%20generates%20a%20Years%20and%20Quarter%20columns.%26nbsp%3B%20How%20do%20I%20stop%20this%20from%20happening.%26nbsp%3B%20I%20just%20need%20the%20date%20to%20appear%20in%20its%20normal%20format.%26nbsp%3B%20I'm%20using%20Office%202016.%26nbsp%3B%20Thank%20you.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-185352%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185369%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Field%20Ungrouping%20from%20Years%20and%20Quarter%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185369%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185368%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Field%20Ungrouping%20from%20Years%20and%20Quarter%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185368%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185363%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Field%20Ungrouping%20from%20Years%20and%20Quarter%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185363%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Marissa%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20this%20setting%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20584px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F32684i0BCD2F7839CBF60C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185359%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Field%20Ungrouping%20from%20Years%20and%20Quarter%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185359%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efastest%20way%3A%20Press%20CTRL-Z.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fbfy.tw%2FHkvS%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERead%20further%20...%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632844%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Field%20Ungrouping%20from%20Years%20and%20Quarter%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632844%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F140018%22%20target%3D%22_blank%22%3E%40Marissa%20Clayton%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20this%20is%20an%20old%20thread%2C%20but%20I%20found%20another%20solution%20and%20this%20can%20be%20helpful%20for%20future%20reference.%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20change%20this%20for%20only%20this%20instance%20instead%20of%20the%20other%20reply%20where%20you%20change%20it%20so%20Excel%20never%20groups%20the%20dates%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20simple%20solution%20is%2C%20when%20you%20have%20inserted%20the%20date%20you%20right%20click%20on%20it%20and%20select%20ungroup.%20That%20should%20do%20the%20trick.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Fcontexturesblog.com%2Fwp-content%2Fuploads%2F2018%2F04%2Fpivotdategrouping04_thumb.png%22%20alt%3D%22https%3A%2F%2Fcontexturesblog.com%2Fwp-content%2Fuploads%2F2018%2F04%2Fpivotdategrouping04_thumb.png%22%20border%3D%220%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633113%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Field%20Ungrouping%20from%20Years%20and%20Quarter%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633113%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%20for%20the%20information!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Marissa Clayton
New Contributor

Hello, I'm working in a pivot table and whenever I add a date field it generates a Years and Quarter columns.  How do I stop this from happening.  I just need the date to appear in its normal format.  I'm using Office 2016.  Thank you.

6 Replies

Hi,

 

fastest way: Press CTRL-Z.

 

Read further ...

 

Hi Marissa,

 

Please check this setting

image.png

Hi@Marissa Clayton 

 

I know this is an old thread, but I found another solution and this can be helpful for future reference.

If you want to change this for only this instance instead of the other reply where you change it so Excel never groups the dates again.

 

The simple solution is, when you have inserted the date you right click on it and select ungroup. That should do the trick.

 

https://contexturesblog.com/wp-content/uploads/2018/04/pivotdategrouping04_thumb.png

 

Hope this helps!

Thank you so much for the information!

Related Conversations