Forum Discussion
Date Formatting Won't Change
- Finally figured this out.
Change the date format of your computer from the taskbar.
Regardless of timezone and all, go to your task bar> click the time/date > region >then look for additional date, time & regional settings > change date, time and number formats> additional settings> then go to the date tab and you can manually set the format by using the MMM dd yyyy or whichever format you want it in. Restart your computer and it should work on excel.
Wew
Chris,
1) Don't format all cells as text before you start to work with them, keep default format (General).
2) Enter the date not as on my screenshot, but in one which you see in your formatting options. We may have different default date formats.
After that =A2+5 shall work. In behind dates in Excel are just sequential integer numbers starting from 1 which is 01 January, 1900. And 13 Oct 2018 is 43386. On the top is only formatting.
Thanks kindly!
Is there a possibility to amend somewhere the default format to e.g. dd/mm/yyyy ?
Or how is the default date format set?
Is this depending on which version one works?
Thank you!
Chris, that's Windows setting, not Excel one. Press Win+R, here "control international" and Enter.
In opened windows you may check / change default formats
Note, if you change format here that affects all your applications, not only Excel.
Thanks Sergei,
I found the general settings of windows and amended it. Now it is the way I wanted it.
Thanks so much for your help. Much appreciated and glad it worked out after all.
And also the little formula for the due date works.
Such a small thing to change but if you don't know where it makes you pulling your hair.
I was not aware it is in general settings but thought it must be somewhere in excel :-)
kind regards
Chris
Also, the only way I could get dates in Excel formatted as Text to Date was to use the DATEVALUE formula. (Text to columns did not work for me)
