save text field w/ leading zeros in .csv format & not lose zeros?

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

Guest

I currently have a csv file with a field that has one digit numbers. I need
to create a text field and convert the one digit number to two digit text by
adding a leading zero. I have tried using the concatenate function to add
the leading zero, but when I close the csv file, it reverts back to one
digit. How can I get the file to save the field as text and include the
leading zero?
 
Check your CSV file in Notepad, not in Excel. Excel will frequently convert
your text representation of a number into a number, even though it likely was
written out to disk with the leading zero
 

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
Lead Zeros in Text 6
Open csv file with Leading Zeros 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Need 7 digit number with differnt number of leading zeros 10
Another Leading Zero Question 7
Save as CSV and Retain Leading zero 1
CSV File - Leading Zeros 2

Back
Top