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?

       

      Thanks,

      Sanket.