Discussions
Ensure export field remains as text when export from Netsuite to Excel
We had a issue occur this week with exporting data from Netsuite to a CSV file. One of the fields we exported was a text field in Netsuite that had a long numeric number. When we exported a report as CSV, we then opened the csv file in excel to check it. Excel automatically converted the text cell to numeric and displayed the cell contents in the spreadsheet as scientific notation. However, when we clicked on the cell, we saw the number in the formula bar that matched exactly the field value in Netsuite. We then saved the file. When