View Single Post
  #1   Report Post  
lgardner
 
Posts: n/a
Default 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