Until that happens most of us simply change the CSV extension to TXT and go
from there.


Gord Dibben MS Excel MVP

On Tue, 6 Oct 2009 16:13:03 -0700, John Padden Racine <John Padden
wrote:

As a software developer who integrates Microsoft Excel using .csv files, I'd
like to see the ability to specify an environment option which would cause
all .csv files to be loaded as text rather than general. I'm not talking
about "importing"; the way that works is fine. I'm talking about opening a
.csv file in Excel, which automatically uses general importation. This
strips leading zeroes which can be counter to what is desired from a download
from a server. These are often IDs/Keys to records. Once opened as text,
columns which are numeric could then be specified as such by the user, but
when opened as general, the leading data is lost. Opening .csv files is the
usual way when automating download and launch of a .csv in Excel; importation
is much more difficult to automate. Note: I am also a professor who teaches
Microsoft Office at Wesley College, DE.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc