We can across an interesting use case where a customer that licenses our CloudExtend Excel for NetSuite Analytics App was exporting a saved search that included item numbers, some of which were being interpreted by Excel as date fields. For example, the item named 11-3-30 was recognized as a date in Excel and came across as 11/3/30.
Below you can see the name field is being interpreted by Excel as a date field.
We wanted to help find a solution that did not require any manual adjustments or macros.
What worked for us was to use a NetSuite formula in the search results to reference the name item name field and to prefix the name with a single quote which forces Excel to treat the value as text. In order to do this with a NetSuite formula, you need to use four single quotes in the CONCAT formula as seen below.
Below you can see the new item field name created with the formula which Excel now treats as a general format.