User Profile
FullyFulwood
Copper Contributor
Joined Mar 09, 2023
User Widgets
Recent Discussions
Re: Date in Excel has to be typed in MM/DD/YY format to get it to display correctly as DD/MM/YY
Riny_van_Eekelen Thanks so much for taking the time to reply!!! It worked. Can you believe that a microsoft expert couldnt think of that! I had the Country or region as Australia, but the Regional format was English (US) and should have been English (Australia)2.8KViews0likes0CommentsDate in Excel has to be typed in MM/DD/YY format to get it to display correctly as DD/MM/YY
Excel changes my date in the cell when it I type it as eg 10/3/23 (10th march 2023) When I click out In the cell it automatcially changes to 03/10/23 (3rd October 2023) So I have to type the date in the opposite format so it will flip it to the correct date!!! I have had microsoft help "assisting" by having control of my computer but they did nothing after about 30 minutes.Solved3.1KViews0likes2Comments
Recent Blog Articles
No content to show