Forum Discussion
Solved
Excel - format cells date
Hi. I have resolved how to make a whole spreadsheet default to a year that is not the current year (ie, working in 2022, but wanting all dates to be recorded as 2023) by using the Custom Format: ddd ...
SueB33 As you have discovered, formatting a date by adding a piece of text to it, doesn't change the underlying date. Rather than just typing 20 Oct, type 20oct23.
That's one extra keystroke and excel will recognize it as a date in 2023.
And set the format to ddd dd mmm yyyy
SueB33 As you have discovered, formatting a date by adding a piece of text to it, doesn't change the underlying date. Rather than just typing 20 Oct, type 20oct23.
That's one extra keystroke and excel will recognize it as a date in 2023.
And set the format to ddd dd mmm yyyy
Thank you so much Riny_van_Eekelen
I was hoping not to have to type in the year, but as you point out, it is only a couple of extra keystrokes 🙂
Regards
Sue