Forum Discussion
Format a date the way you want
https://support.office.com/en-us/article/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e The above does not work. If you open a new workbook and enter "2/2" in a general cell ...
I'm afraid if you type 2/2 Excel automatically applies a built-in custom date format which contains just the day and month and thus resembles your entry, namely d-mmm. I'm afraid there is no way to avoid this other than by formatting the cells into which you want to enter this using the number format you do need.