how to resolve incompatibility of saving an excel to csv format

W

WILLIE

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".
 
A

Arceedee

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.
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top