Hi not sure if in correct place, so if not apologies. I am trying to do a mail merge in word, but reading from information in an Excel spreadsheet. Both are set to UK date as is the region/language options on the control panel.
However when I do my mail merge the dates copies across from excel end up being shown as American dates i.e. MM/DD/YY rather than DD/MM/YY.
How can I prevent this from happening.
Thanks
Chris