|Subject:||saving excel sheet as csv|
|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?