Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I imported numbers from an XLS file saved in CSV format but they lost their first digit ! Why ?

April 26, 2017csv digit file format imported Lost Numbers Saved xls

0

Posted

I imported numbers from an XLS file saved in CSV format but they lost their first digit ! Why ?

1 Answer

0

Posted

If you have a file in XLS format (Microsoft Excel), during the file export into CSV format, if your numbers begin by 06XXXXXXXX, the standard XLS column format delete the 0 inside the CSV. For your sending to France, Metropolitan each number has to begin by 06XXXXXXX or 336XXXXXXXXX Tips: Before the export, transform your numbers column by using the custom format : – Make a right-click on the first cell of the column. – Go to Cells format -> “Custom” category – Enter in the “type” field: 0######### or 33########## then confirm by clicking on OK. – Make a double-click on the bottom right edge of the cell to duplicate automatically the format to the others cells. To finish, go to: -File-> Save as… -> File type “CSV”. Now you can import your CSV file.