Save as .csv file removes trailing 00

  • Thread starter Thread starter Geir Holme
  • Start date Start date
G

Geir Holme

Hi all.
I have a XL sheet with one column containing tekst and values. It is
partnumbers. Some of these starts with trailing nulls (the number 0). Like
00AB25 or 00056P-SDF.

It is populated from SQL Server 2000 varchar(30) field.

When I save as .csv file XL removes the trailing 0's and the partnumber in
the csv file changes to AB25 and 56P-SDF. Any ideas how to avoid this?


thanx.

geir
 
If you save as a TEXT file (instead of CSV), using a comma as the delimiter
and double quotes as the text delimiter, it should have an extension of TXT
rather than CSV. Now when you open the file, the Text Import Wizard will come
up and you can specify that this column is to be treated as Text.
 
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

How keep Leading/Trailing spaces when save in Excel? 0
Inconsistent CSV export format 6
Saving file in CSV format 2
Files saved as csv files are actually saved as text files? 4
Saving as CSV File 2
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
How can I make Excel save Unicode CSV data correctly? 0
how do I save korean font in csv file? 1

Back
Top