ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   problem when saving CSV file (https://www.excelbanter.com/excel-worksheet-functions/20700-problem-when-saving-csv-file.html)

mhe

problem when saving CSV file
 

Why the leading 0 (zero) is dropped when I save the excel
file as CSV file? Is there a way not the leading zero not
to be dropped. What should I do to keep the zero leading
on it.

Thanks a lot.

Fredrik Wahlgren


"mhe" wrote in message
...

Why the leading 0 (zero) is dropped when I save the excel
file as CSV file? Is there a way not the leading zero not
to be dropped. What should I do to keep the zero leading
on it.

Thanks a lot.


What do you have in the cell where you want a leading 0 in the csv file? I
guess you could try to format the cells as text, that may help.

/Fredrik




All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com