Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Date displays in word RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Wednesday, November 26, 2008 10:13 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    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