Missing Zero's when copying from XLS to CSV

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

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

Open csv file with Leading Zeros 1
Excel CSV Files; Creating Of 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
leading zero & .csv files 4
How to stop Excel from automatically truncating leading zeros 2
Importing to Excel from csv AND keep leading zeros 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
csv not importing numbers stored as text 1

Back
Top