Re: saving excel sheet as csv

Giganews Newsgroups
Subject: Re: saving excel sheet as csv
Posted by:  Bryan Hessey (Bryan.Hessey.27lb9b_1147261806.5583@excelforum-nospam.com)
Date: Wed, 10 May 2006

Format the (date) column as the third (last shown) occurance of
14/03/2001

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:http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread:http://www.excelforum.com/showthread.php?threadid=540620

Replies

In response to

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