Share via

In Excel, downloaded a schedule program. Date format is 02/26/2024. Want Monday, February 26,2024. Followed help in Excel and nothing changed.

Anonymous
2023-11-28T20:12:24+00:00

I exported a schedule program into Excel. Date format is 02/26/2024. I want Monday, February 26, 2024. Followed the help instructions in Excel and nothing changed. Will work if I manually retype the date, but not copying or pasting.

Microsoft 365 and Office | Excel | For business | Windows

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2023-11-28T23:12:54+00:00

    Hi,

    That entry is most likely not a proper date - looks like the day and month positions have been interchanged. Select the range of dates (appearing in a single column) and go to Data > Text To Columns. On the third screen, select Date > MDY > Finish. This should change the data type of the entries in that column to Dates. Now you may format the entries in this column.

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2023-11-28T23:08:51+00:00

    Excel sees the values as text.

    You can try the following:

    • Select a column with such values.
    • On the Data tab of the ribbon, click Text to Columns.
    • Select Delimited, then click Next > twice.
    • In step 3 of the Text to Columns wizard, select Date and select MDY as format.
    • Click Finish.

    Was this answer helpful?

    0 comments