Forum Discussion
Mail merge date formatting
I have had a few clients mail merging data from excel into word with the correct formatted UK date, but its turning into a US format. is there another way of fixing this instead of the field code way...
You can force it as text instead of a date. for example instead of a cell saying =TODAY() you can have =TEXT(TODAY(),"DD/MM/YYYY")