I am trying to save an excel file into a "CSV" file format, and Excel prompts
me with the message that there is a compatibility problem and that the CSV
format that will be save will not retain its original "column data format ".
the columns that were save as text converted to number and much worst in
"scientific notation".

Sounds like you are having a similar problem to me. I'm no expert but the
Text to data facility allows individual columns to be treated differently and
to select where column breaks are. Have a look.

"WILLIE" wrote:

I am trying to save an excel file into a "CSV" file format, and Excel prompts
me with the message that there is a compatibility problem and that the CSV
format that will be save will not retain its original "column data format ".
the columns that were save as text converted to number and much worst in
"scientific notation".

CSV is merely text. It contains no formatting information. You can look at
the text with a simple text editor such as Notepad to see what you've got.
Bear in mind that if you just open a CSV file with Excel (as distinct from
opening it with a text edxitor), Excel will make its own decisions on the
interpretation of the text it is reading.
--
David Biddulph

"WILLIE" wrote in message
...
I am trying to save an excel file into a "CSV" file format, and Excel
prompts
me with the message that there is a compatibility problem and that the CSV
format that will be save will not retain its original "column data format
".
the columns that were save as text converted to number and much worst in
"scientific notation".