Suppressing auto format in Excel

[Galsaba]

I have a .CSV file that is automatically generated by a program.
Apparently, when the file is opened with Excel, the numeric fields that are
enclosed in double quotes in the file and look like "123,456.1234" are being
formatted by Excel and displayed with only 2 decimals. The cause of the problem
seems to be the comma in the number, which I don't really want to remove.

Is there any way to suppress automatic cell formatting in Excel, so the
contents could be displayed just the way it appears in the source file?

 

[Crosswire]

In the Text import wizard - step 3 of 3 - select the offending colum
and select text format. Excel will then leave the data as is and yo
are free to change it to any format you wish once you have finishe
importing your file into Excel

 

[Galsaba]

You did not give me the answer, because as I stated in my previous posting, I
do no want to do anything in the excel. The csv file will be opened by
customers and I dont want them to use the tools to change format. What I want
is, to set the csv file in such a way that when the excel file is opon, the
columns will not be formatted to the "number" format, but to "general"

(e-mail address removed)

 

[Dave Peterson]

Then I think you're out of luck.

You did not give me the answer, because as I stated in my previous posting, I
do no want to do anything in the excel. The csv file will be opened by
customers and I dont want them to use the tools to change format. What I want
is, to set the csv file in such a way that when the excel file is opon, the
columns will not be formatted to the "number" format, but to "general"

(e-mail address removed)