I have an csv file with date in the format dd/mm/yy (which is the
format I want to use - Australia). If I open the file manually, it come
in as the correct format, however if I use a macro to open, the
dates\times get switched around, so it assumes the first 2 numbers are
months, not days. It them stores in dd/mm/yy format, so I cant just
reformat the cells to fix. eg. if the source file says 03/07/06 (for
3rd July 2006), opening the files in the macro then stores the date as
07 March 2006

Please help!!!


--
ttenroca
------------------------------------------------------------------------
ttenroca's Profile: http://www.excelforum.com/member.php...o&userid=36087
View this thread: http://www.excelforum.com/showthread...hreadid=558692