SYMPTOM:
When exporting a report to Microsoft Excel with plain text in Strategy Web, attribute names or descriptions of the format type 'xx/yy' are converted into a date notation, as shown below:
CAUSE:
This happens because of Microsoft Excel's default behavior. The cells that Strategy Web generates are in a general format and when given a valid text string with the format such as 10/12, Microsoft Excel will automatically convert it.
ACTION:
When exporting to Microsoft Excel with plain text, in the Export Options enable the 'Export headers as text' check box. By specifying this option, the results are exported to Microsoft Excel in a text-only format where no formatting can be done when rendered as shown below:
