How to convert Scientific Notation in a .CSV file
When Microsoft Excel automatically converts your list of phone numbers into scientific notation, this will hinder being able to upload your .csv file properly into your Smith Dashboard. The scientific notation numbers will not be recognized, and the import will fail until the file is converted.
There is no permanent way to fix this issue yet, but there is a workaround to make your phone numbers save in the correct format.
How to Convert your .CSV file in Microsoft Excel
- Open your CSV file that shows the scientific notion numbers if it is already saved. Or, if you have not already created a CSV file, open a blank workbook in Excel and input your list of numbers.
- Click to highlight a single cell, and in the Formula Bar above add an Apostrophe in front of the numbers.
This will change the number to show correctly and will be noted by the green arrow in the cell.
- Save your list as an Excel workbook file, to begin with. This creates a template that you can edit in the future if needed.
Then save a copy as a .CSV file. Do NOT open this file afterward to edit, or it will run the risk of converting the list back into scientific notation again. Take your .CSV file and upload it straight into your Dashboard.
If you need any assistance, please email us at firstname.lastname@example.org or call us at (650) 727-6484. Our support hours are:
- Monday through Friday: 5am – 9pm PT / 8am – 12am ET
- Saturday and Sunday: 6am - 4pm PT / 9am - 7pm ET