Solved%3a Date Format Issue Excel

Posted on by

Issue

laqa

New Member
  • This video help people to solve date format problem. Sometime date does not display properly in excel. If date: then you will see.
  • I have a macro enabled spreadsheet that I have used for the last 5 years and when 2020 started, in the date column, every time you enter a 2020 date it errors with 'incorrect format please enter mm/dd/yyyy' I've tried everything I can. Any one else have this issue? Any help is greatly appreciated.

Choose the dates in which you are getting the Excel not recognizing date format issue. From your keyboard press CTRL+H This will open the find and replace dialog box on your screen. Now in the ‘Find what’ field put a decimal, and in the ‘replace’ field put a forward slash. Tap the ‘Replace All’ option.

Solved%3a
Joined
May 28, 2021
Messages
12
Solved%3a date format issue excel 2016
Office Version

Solved%3a Date Format Issue Excellent

  1. 2019

Solved%3a Date Format Issue Excel 2016

Issue

Solved%3a Date Format Issue Excel

Platform

Solved%3a Date Format Issue Excellence

Issue
  1. Windows
My Excel just stopped formatting dates. Even if I select the column and use the format cells command again it does not work. I recently changed windows language from portuguese to english, maybe this had an influence. I submitted this post before, but I am submitting it again, because I noticed that it happens only on the Date formatting. I am an university professor and use this command a lot to change dates into numbers to grade students by their task delivery date. Can someone help?