Excel shows bank statement dates as text: how to fix it

October 19, 2026 · 4 min read

You've got your bank transactions into Excel, but the dates won't behave. They sit on the left of the cell instead of the right, sorting puts them in the wrong order, and a formula that subtracts one date from another returns an error. Excel is treating them as text, not dates.

The cause is nearly always one of three things, and each has a quick fix.

How to tell

Click an empty cell and type =ISNUMBER(A2), pointing at one of the dates. Excel stores real dates as numbers, so TRUE means it's a date and FALSE means it's text. Text dates are also usually left-aligned, and sometimes show a small green triangle in the corner.

Cause 1: the date is the wrong way round for your settings

This is the most common one. A UK, Australian or European bank writes 3 April as 03/04/2026. Excel set up for the US reads that as 4 March, and when the first number is over 12, as in 25/04/2026, it can't read it as a date at all and keeps it as text. The result is a column where some dates are wrong and others are text, which is worse than all of them failing.

The fix is Text to Columns, which lets you tell Excel which order the date is in:

Select the date column.
Go to Data → Text to Columns.
Choose Delimited and click Next, untick every delimiter, and click Next again.
Under Column data format, choose Date and pick the order the file uses: DMY for day first, MDY for month first.
Click Finish.

Every date in the column is now converted the same way. Check a few against the statement, especially ones early in the month, where day and month could be read either way.

Cause 2: there's extra text in the cell

Some banks write the day of the week next to the date ("20/11/2025 THU"), add a time, or leave a space or an apostrophe in front. Any of these turns the cell into text.

For a weekday or time after the date, use Text to Columns with Space ticked as the delimiter, set the date column to Date (as above), and choose "Do not import column" for the rest.
For stray spaces, Find and Replace a space with nothing on that column, or use =TRIM(A2) in a helper column.

Cause 3: the cells were formatted as Text

If the column was formatted as Text before the dates went in, Excel keeps them as text even after you change the format, because changing the format doesn't convert what's already there. Change the format to a date format, then run Text to Columns on the column (just click Finish) to make Excel read each cell again.

Two-digit years

A date like 03/04/26 can trigger Excel's error check. Click the warning triangle and choose Convert XX to 20XX to turn it into a four-digit year.

In Google Sheets

Sheets reads dates according to the spreadsheet's locale. If day-first dates come in wrong or as text, go to File → Settings, change the locale to the bank's country (United Kingdom for day-first dates, for example), and paste the data again. To split off a weekday or time, use Data → Split text to columns.

Avoiding it next time

Dates written year first, as 2026-04-03, can only be read one way, and both Excel and Sheets recognise them whatever their settings. The bank CSV converter can rewrite a bank's CSV with every date in one consistent format, and the statement converter turns PDF statements into Excel workbooks with real date cells, so there's nothing to fix.