Mine looks fine too until I close the file and then re-open it then the date
displays in the American format

"NickHK" wrote:

Crewman,
I cannot reproduce you problem. Looking at the csv text file, the date is
format as it appeared in Excel.

NickHK

"Crewman" wrote in message
...
When saving an excel file with (SaveAS) FileFormat:=xlCSV the file has a
cell with =TODAY(). After saving the file the date it looks ok (it is in
the
Australian form dd/mm/yyyy) but when it is saved using the above mehtod
the
result is an American Date