+ Post New Thread
Results 1 to 2 of 2
AV and Multimedia Related Thread, Problem with date when merging excel data in word in Technical; When I merge excel data in word the date go to US format, how do I keep the date as ...
  1. #1
    CatherineMay's Avatar
    Join Date
    Jun 2011
    Location
    Wigan
    Posts
    68
    Thank Post
    24
    Thanked 5 Times in 3 Posts
    Rep Power
    7

    Problem with date when merging excel data in word

    When I merge excel data in word the date go to US format, how do I keep the date as UK?

  2. #2
    soveryapt's Avatar
    Join Date
    Jan 2009
    Location
    Lancashire
    Posts
    2,402
    Thank Post
    648
    Thanked 277 Times in 244 Posts
    Rep Power
    78
    I seem to remember there being date options in the Merge Fields within Word, certainly in Office 2003, but I've not really done much merging of stuff for a few years .. but if you have a look at the merge fields (double clicking in edit mode should bring up any formula stuff) you should be able to check that ..

    Failing that, is Word itself set to location as being the UK and not US as that could also be defaulting it back "home" ..

  3. Thanks to soveryapt from:

    CatherineMay (6th July 2011)

SHARE:
+ Post New Thread

Similar Threads

  1. excel date field to general numbers
    By djones in forum Scripts
    Replies: 3
    Last Post: 4th August 2009, 09:51 AM
  2. [MS Office - 2003] Merging multiple word (.xml) documents [SOLVED]
    By ChrisH in forum Office Software
    Replies: 3
    Last Post: 16th December 2008, 07:46 PM
  3. Merging data in excel
    By Mr_M_Cox in forum Windows
    Replies: 10
    Last Post: 31st October 2008, 11:43 AM
  4. [MS Office - 2007] Auto enter date into Word
    By tw15ns in forum Office Software
    Replies: 0
    Last Post: 28th September 2008, 09:31 AM
  5. Merging data from two cmis datasets
    By gskelton in forum MIS Systems
    Replies: 1
    Last Post: 5th July 2007, 10:47 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •