Excel Sort Dates: Why You See A to Z and How to Fix It

Errors & fixes · Updated November 19, 2026

If Excel offers only A to Z and Z to A when you try to sort dates, it may be treating the entries as text rather than as real dates. Check the values, convert any text dates to date values, then sort using Oldest to Newest or Newest to Oldest; the A-to-Z labels in some ribbon commands can also be generic, so confirm the result rather than relying on the wording alone.

Why Excel may show A to Z

Excel stores a genuine date as a number, with a date format controlling how that number appears on screen. For example, a cell can display 4/7/2025 while holding a numeric date value. When Excel recognizes the selected column as dates, its date-specific sort choices are typically Oldest to Newest and Newest to Oldest. If a menu offers only A to Z and Z to A, one common explanation is that the entries are text strings that look like dates.

There is an important wrinkle: some Excel commands use broad labels such as Sort A to Z and Sort Z to A for quick sorting, even when you are working with dates. Those labels do not, by themselves, prove the dates are stored as text. For a clearer check, open the full sort dialog using Data > Sort and inspect the Order choices for the date column. If Excel recognizes the values as dates, date-specific choices should be available. If it treats them as text, the choices are usually alphabetical.

Text dates often arrive from copied web pages, exported reports, CSV files, or systems that use a different regional date convention. A column can also contain a mixture: some rows are real dates, while others are text. That mix can make the sort choices confusing and can leave rows in an order that appears partly chronological and partly arbitrary.

How Excel stores and sorts dates

In a standard Excel workbook, dates are represented by serial numbers. The number identifies a day in Excel’s date system; the cell’s number format determines whether it is displayed as 4/7/2025, 7-Apr-2025, or another date style. Sorting real dates means sorting those underlying values, not sorting the visible characters. A format change can alter the appearance of a date, but it does not turn text into a date or change the date’s underlying value.

Text behaves differently. Excel sorts text alphabetically, comparing characters from left to right. For example, text dates written as 1/10/2025 and 1/2/2025 may sort in an order that is not chronological, because the text is being compared as a string rather than as a calendar date. Text written consistently as year-month-day, such as 2025-01-02 and 2025-01-10, may happen to sort chronologically as text, but that coincidence does not make the entries usable as date values for date calculations.

Check whether the cells contain real dates

Before changing the data, inspect a few entries, including the first and last rows and any entries that look unusual. Select a cell and look at the formula bar and the Number Format control on the Home tab. A date display format is a clue, not proof: a text string can be made to look date-like, and a real date can be displayed in an unexpected number format.

For a practical test, temporarily change a sample cell’s number format to General using Home > Number Format. A real date will usually display as a serial number; text will remain text. Restore the preferred date format afterward. Alignment can offer another clue—numbers are commonly right-aligned by default and text left-aligned—but alignment is easy to change manually, so do not treat it as a definitive test.

Then open Data > Sort. Choose the date column in Sort by and check the Order list. If Oldest to Newest and Newest to Oldest are available, use one of those options. If only A to Z and Z to A appear, inspect the column for text values, blanks, error values, or inconsistent entries. The full dialog is more informative than guessing from a quick-sort button.

Convert text dates into date values

For a column of consistently formatted date text, Excel’s Text to Columns tool can often convert the entries without splitting them. Work on a copy first, especially if the source data is important. Select the date cells, choose Data > Text to Columns, select Delimited, and choose Next. Clear any delimiter selections so Excel does not split the date into separate fields, choose Next, then select the date order that matches the source—for example, MDY for month/day/year or YMD for year-month-day. Choose Finish and check several converted cells by changing their number format to General.

The date order matters. The text 03/04/2025 could mean March 4 or April 3, depending on the source convention. Selecting the wrong order can create valid dates with the wrong meaning, so confirm the source system’s format before converting. If the text contains month names or other unusual formats, conversion may depend on Excel’s regional settings and the exact wording.

For a single recognizable text date in A2, the formula =DATEVALUE(A2) can return an Excel date value. Format the result as a date, then fill the formula down if appropriate. DATEVALUE relies on date text Excel can interpret under the computer’s regional settings; ambiguous values may be read differently or may not convert. For example, a recognizable US-style 3/14/2025 in A2 should resolve to March 14, 2025 on a system that interprets month/day/year. Check the results before replacing the original column, and retain the source data until the conversion is verified.

Fix mixed dates and imported data carefully

If only some rows behave like text, do not assume one conversion step fixed the whole column. Filter or inspect the entries, identify which values failed to convert, and correct those individually or use a conversion method suited to their format. Watch for leading apostrophes, spaces before or after the date, nonbreaking spaces copied from a website, and entries such as N/A mixed into the date field. These can prevent consistent recognition.

Also check for dates stored as text in different conventions. A column containing 2025-04-07, 4/7/2025, and 07/04/2025 may represent inconsistent formats—and the last two could be interpreted differently depending on locale. If the data comes from a CSV, confirm the source’s date convention and import settings rather than assuming Excel has inferred it correctly. In a larger or recurring import workflow, Power Query can be used to set the column’s data type and locale during transformation; verify the preview before loading the results.

After converting, apply a consistent date format, such as a day-month-year format that avoids ambiguity, and sort again. Consistent display makes it easier for people to review the results, but remember that formatting is separate from conversion: changing the appearance alone does not repair text values.

Sort the whole list, not just the date column

A correct date sort can still damage a worksheet if only the date cells are sorted while the related names, amounts, or notes stay in place. Select a cell within the complete data range and use Data > Sort. If Excel asks whether to expand the selection, choose the option that expands it so each row stays together. In the Sort dialog, select the date field and choose Oldest to Newest or Newest to Oldest. If the data has headers, make sure My data has headers is selected so the header is not sorted into the records.

Excel tables make this easier because sorting a table column keeps the other fields in each row together. Click the filter arrow in the date column and choose the date sort option when available. For a multi-level sort—for example, date first and department second—use Data > Sort and add a level. Decide whether equal dates should remain in their existing order or be sorted by another field.

When dates include times, sorting uses the full date-and-time value even if the cells display only the date. Two entries that look identical may therefore appear in a particular order because one has an earlier time. If the sequence seems unexpected, format a sample cell to display a time as well as the date, or inspect its value in the formula bar. Do not remove times unless the task requires it.

Why a successful sort can still look wrong

First check whether the dates were interpreted in the intended regional order. A sequence that is correctly sorted as April 3, then March 4, may look wrong if the original text was meant as day/month/year but Excel interpreted it as month/day/year. Second, look for blanks and non-date entries. Depending on the data and sort, blanks or text values may group separately from dates rather than appearing in the chronological position you expected.

Next, confirm that the entire dataset was included. A blank row can make Excel treat one worksheet as separate blocks, and manually selecting only one column can separate dates from their corresponding records. Check for filters that hide rows, too: a sort can reorder visible records while hidden rows make the overall sheet harder to interpret. If the sheet is shared or important, save a copy before experimenting so you can compare the original data with the corrected result.

Frequently Asked Questions

Does A to Z always mean Excel thinks my dates are text?
No. Some quick-sort controls use generic A-to-Z wording. Open Data > Sort and check the Order list; date-specific choices are a better indication of how Excel is treating the selected values.

Why does changing the cell format not fix the sort?
Number formatting changes how a value is displayed, not what it is. If the cell contains a text string, choosing a date format usually leaves it as text. Convert the value first, then apply the display format you want.

Can dates that look identical sort differently?
Yes. They may contain different times, or one may be a real date while another is text. Display the time or test the underlying values, and check whether the entries use consistent formats.

What is the safest way to sort a date column with other data?
Use Data > Sort from within the complete data range, expand the selection if prompted, and confirm that the header row is identified correctly. Sorting an Excel table column is another practical way to keep each row’s fields together.

Why did Excel interpret 03/04/2025 incorrectly?
The string is ambiguous: it can mean March 4 or April 3. Excel may interpret it according to regional settings or the conversion option you selected. Confirm the source convention before converting or sorting.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.