Forum Discussion
Solved
date column formatting
I want to list dates in random order in a left column on a sheet of expenses. Never had a problem previously, but having upgraded my system with a new computer and latest Excel worksheet, my dates no...
- Number Format > Date or Number Format > Custom.
Did u find a solution? Also have a new computer now my date inputs gone crazy. I enter like 15.05.2020 and I get 15.5.20 or 15.5.2020 both formats in the same sheet. I want to change a date it jumps to american input 5/15/20 - quite anoying. If you got any idea what this is I would appreciate.
Dietmar5 It looks like you need to change regional and date format settings for your new computer.
Win+R
control international
and here check both Format and Administrative tabs.
