Disable automatic conversion of cell format?

  • Thread starter Thread starter Christopher Reitz
  • Start date Start date
C

Christopher Reitz

Hello,
i'm using Excel2002 for editing CSV-files which are exported from
database tables. In this files i have per example a lot of cells with
dates, which are formated in us style. The problem is excel converts
this cells automatically in german style (i have the german version of
office). Some other cells, mostly with ints are converted in something
else too. Is there a posibillity to tell excel to convert nothing
automatically? In the preferences and help files i've nothing found
about that.

Greetings,
Christopher Reitz
 
Hi
one way:
- save the file as '*.txt' file
- use the text import wizard to open the file
 
You must log in or register to reply here.

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

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
How to Export Gmail Emails to PST Format? 4
How can I migrate MBOX to PST? 2
How can we convert OST to PDF file format? 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Converting "uppercase" string data to "lower case" in CSV file 2
Disable conversion from text to number from .csv file 2

Back
Top