Opening CSV Files

A

Andrew Young

Does anyone know how I can open a CSV file in Excel and
preserve any leading zeros. I thought that if the values
in the CSV file are wrapped in quotes Excel would treat
them as Strings but it doesn't. Is the only way to do this
is to use OpenText and set the columns to Text?

Thanks,
Andrew
 

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

CSV files and having numbers and strings in there... 9
Forcing Excel to Import .CSV data 2
Excel CSV Files; Creating Of 3
Excel VBA macro to auto import new CSV file from fixed directory 1
VBA SaveAs function generates blank CSV file 4
parse csv file contents into powerpoint textbox Autoshapes 0
Word macro that can call cells out of Excel for a find and replace 0
"/r/n" CSV file In Excel 0

Top