Forum Discussion
Displaying the date 01-01-21 as Jan
Hi all Firstly, i'm so glad i found this forum and thank you for your help this far. In cells I require the months of the year, Jan, Feb, March April etc. Without having to write it in words,...
Depends on your default Windows short date format Excel could automatically convert two digits date month into full date of the current year displacing in date month. For example, my default format is
yyyy-mm-dd
When I enter digits as in the right it converts into the date as on the left
With other locale you may try 01/01 or 01.01
More about that is here
Excel works with two-digit year numbers - Office | Microsoft Docs
Change the date system, format, or two-digit year interpretation - Excel (microsoft.com)