Excel date column names as date serial value

1

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?

example

2

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)

image
image1042×585 18.2 KB