Forum Discussion
Excel Date formatting
I have just bought MS Office H&S 2019. I have been using excel for years, but have just encountered a strange problem. I am trying to copy a printed spreadsheet on to my computer so that I can answer...
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.