Jul 05 2018 12:35 AM
I wonder if anyone could help me please?
Its probably really simple but I can't for the life of me get Excel to do as I would like.
On all our company graphs/pivots etc, date is displayed as 18/06 (yy/mm) I have tried using a custom format but it always defaults to a full date 01/06/2018 in the display bar even though displaying correctly in the data
It causes havoc for my pivots.
How can I have the column format my dates as YY/MM to display in the data and in the display bar?
Please?
Thank you
Clair
Jul 05 2018 01:25 AM
Jul 05 2018 01:47 AM
Rather than having one entry per month, it creates one column per date, I inherited the spreadsheet, so older months are actually in YY/MM when I copy that down and change the month in the formatting bar, it goes straight to full date. Even though that column is custom formatted YY/MM it still puts new entries to full date (in the ribbon even though displaying in the actual data as YY/MM) so the custom formatting changes the display but not wherever it pulls from and display in the ribbon.
I have attached (I hope) an example of my spreadsheet which I hope will help explain what I mean
Thank you
Clair
Jul 05 2018 02:27 AM
SolutionJul 05 2018 05:17 AM
Aug 02 2018 04:27 AM
Aug 24 2018 07:12 AM
Apr 29 2019 08:26 PM
Hi
i have a similar problem however converting my column to text didn't help. In the cell the date is displayed thus:
05-Oct-1980 |
On the ribbon the date is displayed thus:
10/5/1980
I am trying to strip out the year from the dob so I can calculate the age.
Please help,
Catherine
Apr 30 2019 12:14 AM
Jul 05 2018 02:27 AM
Solution