Remove leading zero in xls when converting to csv forfield contain

G

Guest

2 Character columen contains both character and numerics, example 4B and 02.
The 02 is converted to 2 in the CSV file regardless of whether the cell is
formatted as general, text, or custom. I also used a value of '02 to identify
it as text value and it still converted it. How do I prevent it from removing
the leading zero? Thanks
 
D

David Biddulph

I suggest that you look in your csv file using Notepad. I think you'll find
that the leading zero is still there. You're losing it when you use Excel
to read the csv. If you don't want Excel to make assumptions on what format
you want the data on import, rename from .csv to .txt, then Excel will give
you a wizard which allows you to specify the columns as being text, which
won't lose your leading zeroes.
 

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

leading zero & .csv files 4
Leading Zero dropping off after export to Excel 3
Display leading zeros in numeric value without converting to text 4
Converting xls to CSV file - dropping leading 0s 1
data truncates when converting .csv to .xls 5
Exporting ZIP code to CSV drops leading zero 2
Numeric values as character in CSV 3
Leading Zero in .csv format 5

Top