Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel file deleted. Now howdo you delete file NAME | New Users to Excel | |||
Why can I not open an Excel Compound file with Office Excel xp? | Excel Discussion (Misc queries) | |||
Problem Opening An Excel file. - by yk | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
In Excel: If I know a file has 147,000 records, but Excel will on. | Excel Discussion (Misc queries) |