converting CSV file

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi, I have a huge csv file with 64739 records. In these records I have
a column with numbers (i.e: 0.0791 or 2.4564); on one computer (winth
excel 2002 or 2003) it converts the file without problems, but on the
computer that needed the conversion, some of the fields are with a
date format, and its impossible to convert them back. example: one
field is 0.026 and on the "bad" machine it comes with a date of jan 62
and the code is 01.01.8462 I looked in the CSV file, it has no space
before or after, with two ;; separating fields.

I tried to reinstall office to no avail.

Any help really appreciated

Simon
 
Hi
check the Windows regional settings. Seems that on the second machine
the dot is used as date delimiter
 

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

Back
Top