Excel dates import as numbers

#1

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?

#2

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.

#3

Thanks very much - I figured it out

#4

You’re welcome!