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