Need help with Scientific Notation and converting back to a number

[banello]

HEllo, Its been awhile. I have a file that I am exporting. It contains FedEx tracking #'s. I can export he file in csv, but the file converts to scientific notation. Below is a snap shot of before and after I convert. Please help any assistance would be great. Thank you! I did try what Microsoft suggested copy to notepad and import data, but it did not work.

Before Converting to CSV, in the website

After Export to CSV

 

[Marc L]

Hi,​

​

just import the column as text …​

 

[banello]

Hi,​

​

just import the column as text …​

I do not have that option, it opens automatically in Excel as a csv. it does not allow me to save first.

 

[Marc L]

​

Use the Excel feature 'Import from file' in the Data tab where you can choose each column data type …​

​

… or when you select a cell if the value is correct in the formula bar then just format the cells as text rather than a number !​

 

[banello]

​

Use the Excel feature 'Import from file' in the Data tab where you can choose each column data type …​

​

… or when you select a cell if the value is correct in the formula bar then just format the cells as text rather than a number !​

Marc, thank. for some reason, when I export the file, it automatically opens in Excel and convert the numbers in the field. I tried your suggestion and it did not work. Thanks! Below is what comes thru in excel.

Example.csv
	A	B	C	D	E	F
1	Shipment	Ship Date	Order #	Order Date	Track Title	Track Number
2	600000112213.00	4/1/2021 6:15	600000025112.00	4/1/2021 7:38	usps - Express	1.37187E+11
3	600000112214.00	4/1/2021 6:15	600000025117.00	4/1/2021 12:01	usps - Express	1.37187E+11
4	600000112751.00	4/2/2021 6:46	600000025113.00	4/1/2021 10:25	usps - Standard	9.40552E+21
5	500000351578.00	4/2/2021 6:46	500000024925.00	4/1/2021 11:00	usps - 01	9.40012E+21
6	500000351579.00	4/2/2021 6:46	500000024926.00	4/1/2021 11:00	usps - 01	9.40012E+21
7	500000351580.00	4/2/2021 6:46	500000024927.00	4/1/2021 11:00	usps - 01	9.40012E+21
8	500000351581.00	4/2/2021 6:46	500000024928.00	4/1/2021 11:00	usps - 01	9.40012E+21
9	500000351582.00	4/2/2021 6:46	500000024929.00	4/1/2021 11:00	usps - 01	9.40552E+21
10	500000351583.00	4/2/2021 6:46	500000024930.00	4/1/2021 11:01	usps - 01	9.40012E+21
11	500000351584.00	4/2/2021 6:46	500000024932.00	4/1/2021 11:01	usps - 01	9.40012E+21
12	500000351585.00	4/2/2021 6:46	500000024933.00	4/1/2021 11:01	usps - 01	9.40012E+21
13	500000351586.00	4/2/2021 6:46	500000024934.00	4/1/2021 11:04	usps - 01	9.40012E+21
Example

 

[Marc L]

See where the file is saved on the local disk so you can import it with one of the Excel features or under VBA or via PowerQuery …​