3 Replies Latest reply on Jul 19, 2018 9:02 PM by Naveen B

    How to Make Month Formatting Consistent?

    Sanket Kelkar

      Hi Team,


      I have a simple sheet with continuous months shown in a discrete way in columns and sum(sales) in rows as shown below - Also as per my user request, I have selected the date format to "14 March 2001". As shown, I am getting "01 June 2017", "01 July 2017" etc.


      My users drill-down the months to weeks using the "+" symbol, they get week wise data. Now when they roll-back to months using the "-" symbol, the month formatting goes away and they see "March 2001" which is not what I want. I am looking for "14 March 2001". PFA my workbook.



      Am I missing something? Can someone please explain this behaviour and do we have any workaround for this?