My csv file contains long number or number that starts with 0, when file is opened the number become broken, what should I do?


My csv file contains long number or number
that starts with 0, when file is opened
the number become broken, what should I do?
Solution

Instead of opening the CSV file directly in Excel, try importing it by clicking Data > From Text, working through the first two dialog boxes in the Import Text Wizard, and in the last dialog box, selecting Column Data Format: Text for each column that should not be interpreted.

"Import a csv" means you open a new excel sheet and click "Data > Import from Text", rather than double click the .csv file from your folder.

Ref: MS Office Community

***Fin***



Article Number: 827
Posted: Mon, Dec 14, 2020 3:25 PM
Last Updated: Mon, Dec 14, 2020 3:25 PM
Posted: Holistic Tech [info@holistictec.com]

Online URL: https://www.soldeazy.com/support/article.php?id=827