Re: saving excel sheet as csv

Giganews Newsgroups
Subject: Re: saving excel sheet as csv
Posted by:  Bryan Hessey (
Date: Wed, 10 May 2006

Format the (date) column as the third (last shown) occurance of

This retains the format required.


Tolga Wrote:
> 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?

Bryan Hessey
Bryan Hessey's Profile:
View this thread:


In response to

saving excel sheet as csv posted by tolga on Wed, 10 May 2006