I cannot understand why certain fields within my mailmerge document are not displaying the proper formats despite my switches.

My datasource is an Excel worksheet.

I have time fields, that are displaying in their decimal equivalents rater than the "h:mm AM/PM" format coded.
{MERGEFIELD "Start" \@ "h:mm am/pm"}
The data in excel is a time value formatted as "h:mm AM/PM".

I have one date field displaying it's serial value rather than the "d -MMM" format coded.
{MERGEFIELD "close_date" \@ "d-MMM"}
The data in Excel, a number, is 41477, and this is how it's displaying in the mailmerge document. Should be 22-Jul.



Cross posted here.