https://netsuiteprofessionals.com logo
m

michoel

05/03/2017, 2:15 AM
Best way I find is to open Excel to a blank document, then import the CSV via "Data > From Text", making sure to select all columns as Text in Step 3 of the Wizard
r

Roc127

03/23/2022, 2:04 PM
Happily we have at the moment the full history chat, I have a question related to this topic. I am having trouble with a column when importing the file into NetSuite, being saved as Scientific Notion instead of as a large number or text. When you open the CSV file in Excel, one column with a large number is shown as Scientific Notation. When you open with a text editor, the large number is shown, which I guess it means that the value is stored as that. However, when importing this CSV in NetSuite, that column is still imported as Scientific Notion. I have tried the suggestion in this message, but still no luck. I have tried several methods suggested online, such as this one https://www.teachexcel.com/excel-tutorial/convert-scientific-notation-to-numbers-in-excel_1594.html Any idea on how can I import succesfully this colum into NetSuite?
In other words, if I open the CSV with a text editor, and the large number is shown (no scientific notaiton), which I guess it means that the value is stored as that. Is there any chance that during the import NetSuite behaves like excel and somehow transform it to scientific notation?