G
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" (in the cvs
file) are being formatted by Excel to two-decimal-number 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. This comma in the number tells the excel
that the numbe is a "number" format, so the excel formats the field to
"number".
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?
I do no want to do anything in the excel. The csv file (using excel) 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".
May be there is a code in that I can add to the csv file tellling excel to
disregard formatting?
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" (in the cvs
file) are being formatted by Excel to two-decimal-number 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. This comma in the number tells the excel
that the numbe is a "number" format, so the excel formats the field to
"number".
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?
I do no want to do anything in the excel. The csv file (using excel) 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".
May be there is a code in that I can add to the csv file tellling excel to
disregard formatting?