Date displays in word RRS feed

  • Question

  • 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.





    Wednesday, November 26, 2008 10:13 AM

All replies

  • Hi. What is the method you are using to transfer the data from the excel file into the word? If you are using VBA code then you just have to set the format of the date, eg: Date1 = Format(Date, "dd/mm/yy")
    Sunday, December 21, 2008 12:21 PM