Excel date column names as date serial value

I have a spreadsheet where a few of the column names are dates formatted as mm/dd/yyyy. The values for these columns are non-dates, ie Yes/No.

When I bring this spreadsheet into EasyMorph, they column headers show up as date serial values. Screenshot below. How can I convert this back to their original format?


Hi Mike and welcome to the Community!

You can use the “Rename columns with lookup” action to automatically format column headers as necessary. See the example below.

rename-date-columns.morph (4.6 KB)
Book1.xlsx (9.0 KB)