Mail merge date formatting

Copper Contributor

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? 

1 Reply
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")