problem when saving CSV file

M

mhe

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.
 
F

Fredrik Wahlgren

mhe said:
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.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to prevent leading zero's from being dropped from a CSV file 1
Open CSV as txt data 5
Excel time leading 1st ZERO 3
loosing test fomat after using replace command 1
csv format drops a text character when reopened in Excel 1
Import text file drops leading zero 2
converting 5
Text Output To CSV 5

Top