Excel dates import as numbers

I have two Excel files - both have a date in them. Both columns in Excel are formatted as dates.

When they import one shows as a date and the other shows as a number.

How can I reformat the number one back to a date and why is this happening to the one and not the other?

Hi Gavin, and welcome to the Community!

In EasyMorph, columns can have formatting for numbers. It can be changed when you select a column. See here: Issue with parsing json and formatting the result

EasyMorph tries to auto-detect dates. Sometimes it correctly detects dates, sometimes it doesn’t. In the latter case, just change the column format manually as described above.

Thanks very much - I figured it out

You’re welcome!