I regularly export a CSV file into Excel, where the dates are in the format MM/DD/YYYY (viz, US format). I need to convert these to YYYYMMDD (Australian format), and am using the code, below. However, what happens is that dates such as 5/1/2010 get converted to YYYYDDMM, whereas dates such as 30/1/2010 get correctly converted to YYYYMMDD. How can I force all dates to be converted to YYYYMMDD?

Please Login or Register  to view this content.