Excel not recognizing Dates since upgrade Hello. Recently, my Office was upgrade

Question

Excel not recognizing Dates since upgrade

Hello. Recently, my Office was upgraded to Office 365 ProPlus. However, now for some reason, even when I open a brand new workbook in Excel, and I manually type in a date like 9/26/2014, it is not recognizing it as a date? So none of my previous macros are working properly due to several issues with these types of formatting issues. At first I thought it was possibly something wrong with my install, so I uninstalled everything, ran CCleaner and then re-installed. However that didn't fix the issue. I can work with updating vba code as needed for upgrades, but how do I handle it not recognizing what the cell contents are? I had even tried formatting a cell as a date then manually typing in a date but it still did not recognize the data as a date. Does anyone have any suggestions or a link to an answer to this type of issue?

Explanation / Answer

It looks to me as string looking as a date but is not a date.

Try this: =ISNUMBER(A1)

If it returns FALSE it is text.

Check you regional options in the control panel how dates are formatted.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.