Missing Zero's when copying from XLS to CSV
 

I wonder if anyone can help me with this problem, i have an excel spreadsheet
that has a column with a series of numbers that have 6 numbers in each cell,
now when i save this excel spreadsheet as a CSV it removes all the leading
zero's therefore if something was in Excel as 000001 it comes over as 1. Is
there anyway to get it into a CSV as what it was originally. Any help would
be much appreciated

Have you looked at the .csv file in Notepad?

I bet you're losing the leading zeros when you re-open the .csv file in
excel--not when you save it as a .csv.

lgardner wrote:

I wonder if anyone can help me with this problem, i have an excel spreadsheet
that has a column with a series of numbers that have 6 numbers in each cell,
now when i save this excel spreadsheet as a CSV it removes all the leading
zero's therefore if something was in Excel as 000001 it comes over as 1. Is
there anyway to get it into a CSV as what it was originally. Any help would
be much appreciated

--

Dave Peterson