text format in csv file
 

If you rename the file to have a .txt extension, then you can use opentext
to specify that the column be brought in as Text.

If you leave the extension as .csv, then excel will ignore you and do what
it wants.

Regards,
Tom Ogilvy


"Ramissah" ` wrote in message
...
I have a file that has a text field that has leading zeros
in a csv format. When I open the csv file the leading
zeros are deleted. I created a function to add the zeros
back to the field. However, I do not know how I can force
the field to remain a text field and preserve the leading
zeros.

Any suggestions?

TIA,
ramissah