Jan 06 2020 09:50 AM
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 now show only the month and year, but not the day. My previous version of Excel allowed me to show dates as follows: Dec 5, Dec 12, etc...... but now all I can show is December 2019 without the specific date. How do I only show the month and date without the year, independendly of any formula?
Jan 06 2020 09:54 AM
SolutionJan 04 2021 01:23 PM
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.
Jan 05 2021 12:58 AM
@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.
Jan 06 2020 09:54 AM
Solution