CSV files have a specification.....! (Yup...)

One of the things it states is that dates should be in the format
YYYYMMDD. It's then up to the receiving application to reformat these
as appropriate.

If you can, get the output changed to conform to the specification,
otherwise rather than input them into a date variable, enter them into
a string and then convert that to a date which will give you control
over the format of the date.


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=394524