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?

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...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=540620

That should, of course, read that in your original .xls, where you have
correct dates, set the correct format, then do the .csv save.

--


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

This retains the format required.

--


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=540620

Hi, Thanks for the response however, not sure what you mean by the third
occurance of 14/03/2001. I've checked in the Format Cells, and can only find
the format i need in the custom category. It's when i select this format
that it changes in the CSV file to the wrong format. If it's any help i'm
using office 2000.

"Bryan Hessey" wrote:


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...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=540620

In Office 2003, when I rightmouse a cell and Format Cells, then select
Date I see a number of presented formats.

The first is *14/03/2001
the third is 14/03/2001
the Eighth is 14/03/2001

Format your original date column with that (eighth) format and it will
retain its shape after a saveAs .csv

If Excel 2000 is very different, then copy your date to a number of
columns and format each with a variation of date format to see which
survives the .csv save (not really scientific, but practical)

Hope this helps.

--

Tolga Wrote:
Hi, Thanks for the response however, not sure what you mean by the
third
occurance of 14/03/2001. I've checked in the Format Cells, and can
only find
the format i need in the custom category. It's when i select this
format
that it changes in the CSV file to the wrong format. If it's any help
i'm
using office 2000.

"Bryan Hessey" wrote:


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...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=540620




--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=540620