Notifications
Clear all
Topic starter
I notice when I go to group by Date in 2016 Excel it does not justify the date text for a neat presentation. I tried to change the date field format on the pivot, and also the date format in the source table, then refreshing the pivot; however no avail. If you look below, you this is how my group date field aligns, it is not justifying.
| Row Labels |
| 1/3/2012 - 1/9/2012 |
| 1/10/2012 - 1/16/2012 |
| 1/24/2012 - 1/30/2012 |
| 1/31/2012 - 2/6/2012 |
| 2/7/2012 - 2/13/2012 |
| 2/14/2012 - 2/20/2012 |
| 3/6/2012 - 3/12/2012 |
| 3/13/2012 - 3/19/2012 |
| 3/20/2012 - 3/26/2012 |
| 4/3/2012 - 4/9/2012 |
| 4/10/2012 - 4/16/2012 |
| 5/1/2012 - 5/7/2012 |
| 5/8/2012 - 5/14/2012 |
| 5/15/2012 - 5/21/2012 |
| 5/29/2012 - 6/4/2012 |
| 6/5/2012 - 6/11/2012 |
| 6/12/2012 - 6/18/2012 |
| 6/19/2012 - 6/25/2012 |
| 6/26/2012 - 7/2/2012 |
| 7/3/2012 - 7/9/2012 |
Posted : 01/02/2018 11:00 am
Hi Stephen
Welcome to the forum.
You can change your Windows date format to mm/dd/yyyy or dd/mm/yyyy to display 2-digit day and month.
Hope this helps.
Sunny
Posted : 01/02/2018 12:12 pm
