Forum Discussion
Date in Excel
A coworker has a list of dates she needs to enter in a spreadsheet but she would like to type in the dates without typing the slash key in between the date (example: 040121 instead of 04/01/21) and e...
Excel never recognizes 040121 as the date 04/02/21 by itself. It requires VBA. See Date And Time Entry
It's up to you to decide whether it's worth the hassle.