MS Excel - Open CSV with Long Numbers
- Joel Lipman
- Excel
- Hits: 3616
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).
My Data:
Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989 1457102000000135566,Stanley,01709123456,1457102000000167543 1457102000000135608,David,00331234567890,1457102000000166795
- Account ID,Name,Phone,Record ID
- 1457102000000135533,Joel,00441234567890,1457102000000165989
- 1457102000000135566,Stanley,01709123456,1457102000000167543
- 1457102000000135608,David,00331234567890,1457102000000166795
Account ID Name Phone Record ID 1.4571E+18 Joel 4.41235E+11 1.4571E+18 1.4571E+18 Stanley 1709123456 1.4571E+18 1.4571E+18 David 3.31235E+11 1.4571E+18
- Account ID Name Phone Record ID
- 1.4571E+18 Joel 4.41235E+11 1.4571E+18
- 1.4571E+18 Stanley 1709123456 1.4571E+18
- 1.4571E+18 David 3.31235E+11 1.4571E+18
How?
Firstly, save the CSV file as text file (*.TXT).