My regional settings are currently for UK, which displays dates as dd/mm/yyyy.

If I create a new workbook, and write this simple code:

Range("A1")="01/09/2014"

it appears in cell A1 as 09/01/2014. Why would it assume I was giving it the date in US format, and how can tell it not to?