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...
As posited in the first reply, you can have a permanent change to the date format by following the steps highlighted
You can have whatever format you desire dd-mmm, mm-dd-yyyy, dd-mm-yyyy, dd/mm/yyyy etc.
Yeah thank you Abiola, I got that bit and have always understood the how, thank you. My issue was using 2019, why all of a sudden the straight forward formatting that I have always used before, suddenly wasn't doing what it always used to on the countless Excel spreadsheets I have created previously.
Thank you for trying to help anyway
- Custom forgetting works the same across versions.
You're welcome
