saving excel sheet as csv

Giganews Newsgroups
Subject: saving excel sheet as csv
Posted by:  tolga
Date: Wed, 10 May 2006

Hi,  I'm trying to save an excel file (xls) as a csv file.  However once it's
saved and i re-open the csv file in excel the column containing dates change
from dd/mm/yyyy to mm/dd/yyyy.  Even if i then try to select the column of
dates and change it in the format cells menu it still wont change to uk
format.  I've checked the main system settings which is uk format so that
can't be the problem.  Can anyone help?

Replies