Forum Discussion
johnsboxftm
Feb 06, 2023Brass Contributor
Lazy date entering help
Hello all,
I want to format a cell with the date where all I have to type in is the month and day and excel put the year in automatically.
So I would type in 127 or 0127 in the cell and excel would know to write it out as 1/27/2023.
Is that even possible?
You guys have been great, thank you for all the previous help.
1 Reply
- PipFinyxCopper Contributorjust type in 01/27, excel will default the year to 2023