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