You convert a bank statement or invoice PDF to Excel, then try to sort the rows by date and nothing happens. Filter by month, and Excel offers a flat list of text instead of grouped years. Run DATEDIF or a SUMIFS keyed on a date and you get a #VALUE! error or a wrong total. The data looks fine on screen, but Excel is treating 03/14/2026 as a string of characters, not a date. This is one of the most common problems after a PDF-to-Excel conversion, and it is fixable in a couple of minutes once you know which tool to reach for.
Below is the direct answer, a quick way to confirm the problem, and four methods ordered from fastest to most flexible, including the awkward YYYYMMDD case that trips most people up.
Why do dates come into Excel as text?
Dates come into Excel as text because the converter hands Excel the date as a string of characters, and Excel only treats a value as a real date when it recognizes the format and the regional order. A date like 14/03/2026 will stay as text on a US machine because Excel reads it as month 14, which is invalid, so it leaves it alone. Leading apostrophes, trailing spaces, non-breaking spaces from the PDF, or an unusual separator all keep Excel from parsing the value. Real Excel dates are stored as serial numbers under the hood, so anything that prevents that conversion leaves you with plain text.
How can I tell if my dates are text or real dates?
The quickest tell is alignment: select the column and look at how the values sit in their cells. Text dates align to the left by default, while real Excel dates align to the right. You can also click a single cell and check the Number Format box on the Home tab. If it reads General, the value is almost certainly text; a genuine date shows a Date format. One more check: type =ISNUMBER(A2) next to a date. TRUE means Excel sees a real date (a number); FALSE means it is text that needs converting.
How do I convert text dates to real dates in Excel?
The fastest fix for a whole column is Text to Columns. Select the column, go to Data, click Text to Columns, choose Delimited, click Next twice, then on step three pick the Date option and set the order that matches your data (MDY for US month-day-year). Click Finish and Excel rewrites the column as real dates in place. For formula-based control, use =DATEVALUE(A2) or =VALUE(A2) in a helper column, then copy and Paste Special as Values back over the originals and apply a date format. Pick Text to Columns when you want a quick bulk fix and DATEVALUE when you need a repeatable formula.
How do I use Text to Columns to fix dates?
Select the cells that hold the text dates, open the Data tab, and click Text to Columns. Choose Delimited and click Next, leave the delimiters unchecked and click Next again, then on the third screen choose Date under Column data format and select the order shown in your cells from the dropdown. If your text reads month-day-year, choose MDY; if it reads day-month-year, choose DMY. Click Finish. Excel converts the selection to real dates you can immediately sort, filter, and calculate with. This method handles a few thousand rows in one pass and needs no helper column.
How do I convert YYYYMMDD numbers to dates?
When a date arrives as a solid block like 20260314 (no separators), DATEVALUE will not parse it, so split it with a formula instead. Use =DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2)), which pulls the year, month, and day out by position and rebuilds a real date. This is common with statements and exports that store dates as plain numbers. After the formula fills down, copy the helper column and Paste Special as Values, then format it as a date and delete the original text column. Text to Columns also handles this case if you pick the YMD order on the Date step.
Why does DATEVALUE return a #VALUE! error?
DATEVALUE returns #VALUE! when the text does not match a date format Excel can read for your region, and the usual culprit is hidden characters. Trailing spaces, non-breaking spaces carried over from the PDF, or a stray apostrophe all cause it. Wrap the reference in TRIM and CLEAN first: =DATEVALUE(TRIM(CLEAN(A2))). If the order is the problem (Excel reading a day as a month), DATEVALUE cannot guess it, so use Text to Columns with the correct DMY or MDY setting instead, since that step lets you state the order explicitly.
How do I stop dates from coming in as text in the first place?
The best fix is upstream: use a converter that preserves dates as real values during extraction so you do not clean them afterward. Our PDF to Excel converter reads each column and keeps dates and amounts in formats Excel recognizes, which means fewer text-to-date passes after every conversion. When the source is a scanned or photographed document, run it through OCR PDF to Excel first so the characters are read accurately before any date parsing. Getting the conversion right at the source is faster than repairing a column of text dates by hand every month.
Quick checklist for fixing text dates
Confirm the problem with alignment or =ISNUMBER. For a fast bulk fix, run Text to Columns and set the correct MDY or DMY order. For a repeatable formula, use DATEVALUE or VALUE in a helper column and Paste Special as Values. For solid YYYYMMDD blocks, split with DATE/LEFT/MID/RIGHT or use the YMD order. If DATEVALUE errors, clean hidden characters with TRIM and CLEAN. Once the column is right-aligned and ISNUMBER returns TRUE, your sorting, filtering, DATEDIF, and SUMIFS will all work as expected.
Dates that import cleanly matter most when you are working with financial documents on a deadline. If you regularly pull dates off bank statements, the same approach applies once the statement is in a spreadsheet: convert the PDF first with a tool built for it, such as a dedicated bank statement to Excel converter, then your transaction dates are ready to reconcile. The same is true for dated receipts feeding an expense report, where a purpose-built receipt data extraction tool keeps the purchase date intact from the start. For deeper cleanup, see our guides on numbers that come in as text and losing leading zeros, and link the cleaned data up to your work in PDF to Excel for accountants.