Forum Discussion
Excel Date formatting
In addition, you can use Custom Format
1. Select the Dates i.e 21/02/2020 "dd/mm/yyyy" format
2. Execute CTRL + 1
3. Click on Custom
4. Type in dd.mm.yyyy
Click OK
Thank you Abiola1
That is what I tried to do, like I have done many times before, but instead of changing the date from, for example 02 (for Feb) it left the day the same as was, but changed all the different months to Jan
If 01.03 is converted to 1.03 that means that dot is not your default separator in date format. Applying dd.mmm format to number 1.03 Excel considers the number 1.03 as January 01, 1900 plus 03/24 hours, more exactly as 1900-01-01 00:43:12. Thus it will be formatted as 01.Jan.
Use your default separator (e.g. 01/03) or change it on dot in Win+R, control international, Advanced.
