Thank you!! It seems indicating you are defining a custom format (with ;@) works with any format Excel accepts. All of these worked (with MS Excel, Spanish but probably with all of them when using ;@ and indicating the locale/language as we'll see next). As said, the trick is to save as "Excel 2003 XML", open it as text (Notepad) and search for the definition like <NumberFormat ss:Format="dd\-mm\-yyyy;@"/>. var datetime1 datetime2 / style(data) = {tagattr='type:DateTime format:dd/mm/yyyy;@'}; var datetime1 datetime2 / style(data) = {tagattr='type:DateTime format:dd-mm-yyyy;@'}; /* In XML appears as: <NumberFormat ss:Format="dd\-mm\-yyyy;@"/> so it seems escaping is not necessary when adding the custom format indicator ;@ but as we'll see one should substitute ' with " (HTML) */ And these ones depending on locale/language work too: - This one will show the month in the default Excel language, "16-jun-2016": var datetime1 datetime2 / style(data) = {tagattr='type:DateTime format:dd-mmm-yyyy;@'}; - This one in International Spanish, "16 de Junio de 2016": var datetime1 datetime2 / style(data) = {tagattr='type:DateTime format:[$-C0A]d\ "de"\ mmmm\ "de"\ yyyy;@'}; - This in English (USA), "16-jun-2016": var datetime1 datetime2 / style(data) = {tagattr='type:DateTime format:[ENG][$-409]d\-mmm\-yy;@'};
... View more