in 2003 i have 0 text file conrt to 2007 number

G

geordge7814

i have a file in 2003 excel, one field is in text delimited format. How do i
convert this without lossing the '0' at the beginning of the number.
 
F

Fred Smith

Do you have an Excel file (.xls) or a CSV file?

If it's Excel, 2007 will read it in properly. If it's CSV, specify the field
as text during the open.

Regards,
Fred
 

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

Converting Numbers from Excel to TXT files 2
How do I retain the format of varying numbers in Excel? 6
Columns formatted As Dates Are Exported as a Number to Text 1
Converting excel 2007 to tab delimeter text file 1
Tab delimited text file import on double click 2
Formula for deleting " 1
Puzzling quotes around text 2
Number in text format in CSV file 3

Top