Date Format when using .xlsx Template

AppSheet AppSheet Q&A
1

I am using a .xlsx template as an email attachment template. The column named “Date”, in which the column type is Date, results to a numerical date value in the .xlsx email attachment instead of mm/dd/yyyy format. How can I have it result in mm/dd/yyyy format in the .xlsx file attachment ?

Thanks.

2

Please experiment with the column formatting settings of the XSLX template. For example setting the columns as purely text columns etc.