Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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
0