Share via

Excel Date Formatted As Text

Anonymous
2022-10-25T23:30:46+00:00

I am having difficulty getting Excel to format my dates column as dates. Everything was fine until I migrated my Excel workbook from my Mac Desktop to my MacBook Pro, both using Catalina, with OneDrive. It screwed up every new date I added. (Unfortunately I can't remember exactly what it did that was wrong.) I made the mistake of taking advice I found online that had me changing the date to text. It looks like this in the formula bar: 10/23/2022=ISTEXT(B218) I think I know what's wrong; I need to change the date back to a number but I have not been able to figure out how to accomplish this despite extensive online searches. I am using Excel 365 for Mac; version 16.66.1. Any help will be greatly appreciated!

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 436K Reputation points
    2022-10-25T23:58:32+00:00

    Assuming the textual date only is in cell A1, format cell B1 as [e.g.,] Short Date, then in cell B1 enter the function:

    =DATEVALUE(A10)

    Copy down as necessary.

    If the cell actually contains "10/23/2022=ISTEXT(B218)" the = & everything that follows it needs to be removed.

    If that doesn't provide the desired result please provide a more explicit example of the data as it actually exists in the file.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-10-26T16:35:16+00:00

    The duplicate question has been merged with the original question.- Moderator

    Was this answer helpful?

    0 comments
  3. Bob Jones AKA CyberTaz MVP 436K Reputation points
    2022-10-26T00:04:52+00:00

    Please don't submit an issue more than once. It doesn't get faster results & at best causes duplication of effort. Return to your original message for replies.

    Excel Date Formatted As Text

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-10-25T23:30:37+00:00

    I am having difficulty getting Excel to format my dates column as dates. Everything was fine until I migrated my Excel workbook from my Mac Desktop to my MacBook Pro, both using Catalina, with OneDrive. It screwed up every new date I added. (Unfortunately I can't remember exactly what it did that was wrong.) I made the mistake of taking advice I found online that had me changing the date to text. Please see screen shot below. I think I know what's wrong; I need to change the date back to a number but I have not been able to figure out how to accomplish this despite extensive online searches. I am using Excel 365 for Mac; version 16.66.1. Any help will be greatly appreciated!

    Was this answer helpful?

    0 comments