Forum Discussion
Set an Excel Spreadsheet to return a Default Year
Is it possible to make a spreadsheet default to the following year?
For example, I type 12 Jul and, subject to my date format, the cell displays 12/07/22. I need it to automatically display 12/07/23 as the spreadsheet is for calendar dates in 2023.
Thanks so much
1 Reply
Hello SueB33 !
You can change the date format to a default value.
Example : "2023"-mm-dd
https://support.microsoft.com/en-us/office/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e#:~:text=what%20you%20want.-,Select%20the%20cells%20you%20want%20to%20format.,format%20you%20want%20in%20Type.
