Having a US English version, it isn't something I have a lot of experience
with, but if nothing else, you can write the file with code. A start is to
use Chip Pearson's code and modify it to work with your dates.

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy


"Nijk" wrote in message
...
Hi, I am running a macro to export an xls file to csv. The xls contains
dates
formatted as dd/mm/yyyy. However, when the 'save as' code is executed the
format is lost. The csv file contains mm/dd/yyyy. Any ideas how to retain
the
european format so I get dd/mm/yyyy in my csv?
I have checked my regional settings and have dd/mm/yyyy enabled.
I have seen threads for the reverse issue (csv into xls) but have idea how
to fix the issue of xls to csv.
I am using Office Excel 2003 SP1 if this makes a difference.

Any help would be appreciated.
Many Thanks, Nijk