My default regional settings for a date is dd/mm/yyyy (I'm
in Australia). In an excel data source as well is in any
other Office applications dates are defaulted to the
correct format dd/mm/yyyy, however when date fields are
merged into a document date format switches to mm/dd/yyyy.

I can't seem to find anything which would trigger this
switch, all my setting (Windows, Word, Excel) have a
correct default date format setup. I've re-installed the
MS Office but the error still persists. Could you please
assist in resolving this problem.

Many thanks in advance.