Open csv file with Leading Zeros


G

goshute

Does anybody have any ideas that would force Excel to format all
columns in a csv file as text, especially columns that look like
numbers and have leading zeros?

I need to be able to double click on a csv file and open the entire
file as text. Some of the columns have leading zeros and we need to
keep them.

Now here is my problem:
An ERP application creates the csv files. The users can see the files
and open them in Excel (2007) as long as they do it within the ERP
application.

Things the users can not do:
rename the file with the .txt extension
move the file to a different directory
Open the file via Data>Via Text>etc
Use any other application to open the file

I have tried the following modifications to the personal workbook
without any luck:
format the columns as text
Run a macro when the personal workbook is opened to format the columns
as text

On the back burner:
Changing the associated program for csv files to notepad.
Administrator move the files to a public directory and rename with txt
extension

Mike
 
Ad

Advertisements

J

James Ravenswood

If you REALLY need to use the double-click, then its best to rename
the files as .txt.

This will force the Import Wizard to appear. You can tell the Wizard
that the columns are Text.
 

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

Top