converting CSV file

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
 
F

Frank Kabel

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