Excel file saved as csv - dropping zeros
 

I have an excel file that I save in a csv format. There are some columns
that have numbers in them with zeros as the first numbers that have to remain
(i.e. 001234). The zeros are in the excel file with whatever cell format I
use, but when I save it as a csv and then bring up the csv file, the zeros
are dropped. Any ideas?

Hi, Kathy;
That only happens when you open the .csv with Excel. Open with notepad, and
you will see the leading zeros. I assume you are saving in .csv format so you
can use that data in some other program. Do the zeros show up in that program?
Regards,
Ian.

"Kathy" wrote:

I have an excel file that I save in a csv format. There are some columns
that have numbers in them with zeros as the first numbers that have to remain
(i.e. 001234). The zeros are in the excel file with whatever cell format I
use, but when I save it as a csv and then bring up the csv file, the zeros
are dropped. Any ideas?

Ian, that was the perfect response. Everything looks good when I open in
notepad. Thanks for helping! - Kathy

"IanRoy" wrote:

Hi, Kathy;
That only happens when you open the .csv with Excel. Open with notepad, and
you will see the leading zeros. I assume you are saving in .csv format so you
can use that data in some other program. Do the zeros show up in that program?
Regards,
Ian.

"Kathy" wrote:

I have an excel file that I save in a csv format. There are some columns
that have numbers in them with zeros as the first numbers that have to remain
(i.e. 001234). The zeros are in the excel file with whatever cell format I
use, but when I save it as a csv and then bring up the csv file, the zeros
are dropped. Any ideas?

Hi, Kathy;
Thanks very much for the feedback. I'm glad that did it for you.
Regards,
Ian.

"Kathy" wrote:

Ian, that was the perfect response. Everything looks good when I open in
notepad. Thanks for helping! - Kathy

"IanRoy" wrote:

Hi, Kathy;
That only happens when you open the .csv with Excel. Open with notepad, and
you will see the leading zeros. I assume you are saving in .csv format so you
can use that data in some other program. Do the zeros show up in that program?
Regards,
Ian.

"Kathy" wrote:

I have an excel file that I save in a csv format. There are some columns
that have numbers in them with zeros as the first numbers that have to remain
(i.e. 001234). The zeros are in the excel file with whatever cell format I
use, but when I save it as a csv and then bring up the csv file, the zeros
are dropped. Any ideas?