# Numbers App Date Format: Fix Imported Dates

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-10-15
- Updated: 2026-10-15
- Category: Google Sheets, Numbers and LibreOffice
- Canonical: https://www.fastbankconvert.com/blog/numbers-app-date-format

> Fix the Numbers app date format when imported dates show as text or in the wrong order: cell format, region settings and re-import.
To fix the Numbers app date format for imported dates, first find out whether the cells hold real dates or text. Real dates take a new style from the Date & Time data format. Text dates, or dates with day and month swapped, need the right region set before import, a re-import, or a formula that rebuilds them.

## How can you tell a Numbers app date is text and not a date?

A Numbers app date is text when Numbers did not recognise the string as a date on import. The signs are left alignment, a Data Format of Text or Automatic that does not change the display, and a sort that orders the column alphabetically. A real date sorts in calendar order and accepts any date style you pick.

Numbers formats cells automatically by default. Apple's page on [formatting dates, currency and more in Numbers on Mac](https://support.apple.com/guide/numbers/format-dates-currency-and-more-tan23393f3a/mac) describes this automatic format: Numbers reads each entry and displays it as you typed it. If the string looks like a date in your Mac's region, it becomes a date. If not, it stays text. A column imported from a statement can end up as a mixture.

Check the column in three ways:

1. **Alignment.** With the default style, dates and numbers sit at the right of the cell and text at the left. A ragged column with some dates on each side is a mixture.
2. **Format sidebar.** Select one cell, open the Format sidebar and choose the Cell tab. Change the Data Format to Date & Time and pick a different date style. A real date changes its look. Text stays exactly as it was.
3. **Sort.** Sort the column ascending. Real dates run from earliest to latest. Text dates sort character by character, so 01/02 and 01/12 sit together regardless of the month.

There is a quieter failure too. A date can be real but wrong, with day and month swapped. Numbers shows it as a valid date, so the first two checks pass. The sort reveals it: a statement for March with transactions dated in April, May and December has a swap problem.

## Setting the Date & Time data format in the Numbers app

The Date & Time data format in the Numbers app sets how real dates are displayed. Select the cells, open the Format sidebar, click the Cell tab, and choose Date & Time from the Data Format pop-up menu. Then pick a style from the Date pop-up menu, and a time style or none from the Time menu.

The style menu changes the display only. A cell that holds the 14th of March 2026 can show 3/14/26, 14 Mar 2026 or Saturday, March 14, 2026, and its value stays the same. Sorting, filtering and date arithmetic all use the value.

Apple's page also says you can always return a cell to the automatic format by choosing Automatic from the same Data Format menu. That is useful if you have experimented with styles and want to see what Numbers made of the data on its own.

Two points catch people out:

- **Missing parts are filled in.** Apple notes that if you enter a time without a date, Numbers adds a default value for the date, such as today.
- **Text does not respond.** Choosing Date & Time for a text cell does not convert it. The menu formats a value that is already a date. For text, use one of the fixes in the sections below.

If none of the built-in styles suits you, the Data Format menu also offers a custom format, where you arrange the day, month and year elements yourself. That is handy when you need a sortable display such as 2026-03-14.

## Which Numbers language and region setting decides date order?

The language and region setting decides whether the Numbers app reads 04/03 as April 3 or 4 March. A spreadsheet follows your Mac's region by default. Apple's guide to [formatting a spreadsheet for another language in Numbers on Mac](https://support.apple.com/guide/numbers/format-a-spreadsheet-for-another-language-tan3013d2eb5/mac) explains how to give one spreadsheet its own setting with File, then Advanced, then Language & Region.

The catch is what that setting changes for data already in the table. According to Apple's guide, changing the language and region of an existing spreadsheet changes the language of dates, such as month names, but not the punctuation or the order of day, month and year. Number punctuation, such as decimal points and thousands separators, does change. New data you enter afterwards follows the new setting.

In other words, the setting will not repair dates that were read the wrong way round. A value that Numbers already turned into April 3 stays April 3. The setting matters before the data arrives, which is why the next section is about importing again.

Two more details from Apple's page:

- Choosing System as the language makes the spreadsheet follow whatever Mac opens it. A file that reads correctly on your Mac may read differently on a colleague's Mac in another region.
- You cannot change the setting on a shared spreadsheet. Everyone sees it in the language and region of the owner's computer.

Region differences are not unique to Numbers. Google Sheets and Excel for the web handle locale in their own ways, and [comparing Excel Online and Google Sheets for statement data](/blog/excel-online-vs-google-sheets) covers how each one decides what a date is.

## Re-importing a CSV so the Numbers app reads dates correctly

Re-importing a CSV is the cleanest fix when the Numbers app read dates in the wrong order or left them as text. Set the region to match the statement first, then open the CSV again. Numbers reads the date strings under the new setting, so day-first dates from a UK or European statement come in as the dates they are.

A step list, using an example of a UK statement opened on a Mac set to the United States:

1. Quit Numbers. In System Settings on the Mac, open General, then Language & Region, and set the Region to United Kingdom for now.
2. Drag the original CSV file onto the Numbers icon, so Numbers reads it under the new region.
3. If the columns come in wrong, select the table, open the Format sidebar, choose the Table tab and click Adjust Import Settings. Pick the right delimiter on the Delimited tab, then click Update Table.
4. Check the date column with the sort test before you edit anything else.
5. Set the spreadsheet's own region with File, then Advanced, then Language & Region, and then put the Mac's region back. Dates already read stay as the dates they are.

Apple's guide to [importing an Excel or text file into Numbers on Mac](https://support.apple.com/guide/numbers/import-an-excel-or-text-file-tan9f3c54bdc/mac) notes that you cannot adjust import settings once you have edited the imported table. Do the date check first, and if it fails, start again from the CSV rather than from the edited table.

Re-importing needs the original file. If you only have the edited Numbers table, keep the original CSV next to it next time. The formula route below works without it.

## Rebuilding swapped day and month dates with Numbers formulas

Formulas rebuild swapped day and month dates in the Numbers app when re-importing is not an option. There are two cases. For text dates, split it and feed the parts to DATE. For real dates already read the wrong way round, swap the day and month with DATE, DAY and MONTH, but only for the dates that were actually swapped.

### Case 1: text dates

A text date such as "25/03/2026" can be split by position when every value has the same width. With the text in A2, this formula builds a real date from a day-first string:

```
=DATE(VALUE(RIGHT(A2, 4)), VALUE(MID(A2, 4, 2)), VALUE(LEFT(A2, 2)))
```

If the widths vary, as in "5/3/2026", split on the slashes with TEXTBEFORE and TEXTAFTER instead of fixed positions.

### Case 2: real dates read as month-first

A day-first date such as 04/03/2026 may have become April 3 on a US-region Mac. Swapping the parts gives back 4 March:

```
=DATE(YEAR(A2), DAY(A2), MONTH(A2))
```

Do not fill this down a whole column blindly. In the same import, a value such as 25/03/2026 could not be read month-first and stayed text, so it belongs to Case 1. Mixed columns need both formulas, chosen row by row.

### A worked example of imported dates

The rows below are examples from a UK statement opened on a US-region Mac.

| Example string in the CSV | What Numbers made of it | Fix |
| --- | --- | --- |
| 04/03/2026 | Date: April 3, 2026 | Case 2 formula, gives 4 March |
| 12/03/2026 | Date: December 3, 2026 | Case 2 formula, gives 12 March |
| 25/03/2026 | Text | Case 1 formula, gives 25 March |
| 2026-03-14 | Date: March 14, 2026 | None, already right |

The last row shows why ISO dates in year-month-day order are the safest to exchange. They read the same in every region.

When the formulas are right, copy the new column and paste it over the old one as values, then delete the helper column. Apply a Date & Time style, and run the sort check one last time.

## Two-digit years and month names that trip the Numbers app

Two-digit years and month names are the edge cases that still come out wrong after the region is right. A two-digit year makes Numbers guess the century. A month name in another language may not be recognised at all. Statements that print only day and month leave the year for Numbers to supply.

Each needs its own check:

- **Two-digit years.** A date such as 14/03/26 should become 2026, but an old statement from 1998 printed as 98 may not land where you expect. Add a YEAR column and scan it for values outside the statement period.
- **Month names.** "14 Mär 2026" from a German statement reads as a date only if the spreadsheet's language understands the abbreviation. Replace month names with numbers first, or set the language to match before importing.
- **No year.** Some statements print "14 Mar" and leave the year to the heading. Whatever year Numbers supplies, check it. A statement for December to January needs two different years in the same column.
- **Dates inside descriptions.** Card descriptions often carry a second date, such as "COFFEE HOUSE 03/13". Leave those as text. Only the date column needs converting.

Dates are not the only field that changes with region. Amounts with decimal commas or a currency sign can stay text in the same way, which [currency format in Google Sheets](/blog/currency-format-in-google-sheets) explains from the Sheets side.

Scans add another layer: a misread digit can turn 08 into 03, which looks like a valid date and passes every format check. If your statement was scanned, compare a sample of dates against the page, as described in [converting a scanned PDF to Excel and checking the output](/blog/convert-scanned-pdf-to-excel#checking-scanned-pdf-output-against-the-page). For digital statements, FastBankConvert is being built to put dates in their own column and to warn you before download if the balances do not add up; [ask to hear when it opens](/get-started).