Date Formats

Discussion in 'Word' started by Gillian Simpson, Aug 23, 2017.

  1. Gillian Simpson

    Gillian Simpson

    Joined:
    Aug 22, 2017
    Messages:
    12
    Likes Received:
    0
    Hi - ive merged a list of dates in Excel into a Word document. Regardless of how i format the date in excel, it transfers to Word as 8/23/2017 - i want it to display as Wed 23 Aug 2017 - as it is displayed in Excel i.e. ddd dd mm yyyy - i thought about trying to convert the dates to "text" in excel (woth copy, paste special as values) cos this i reckon wud work - but couldnt get that right - any suggestions pls?
     
    Gillian Simpson, Aug 23, 2017
    #1
    1. Advertisements

  2. Gillian Simpson

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    287
    Likes Received:
    24
    macropod, Aug 23, 2017
    #2
    1. Advertisements

  3. Gillian Simpson

    Gillian Simpson

    Joined:
    Aug 22, 2017
    Messages:
    12
    Likes Received:
    0
    Gillian Simpson, Aug 23, 2017
    #3
  4. Gillian Simpson

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    287
    Likes Received:
    24
    DDE is the last method I'd use to deal with something like this; it's extremely limited compared to the default OLE DB. All you need do is add the switches as described - a trivial undertaking.
     
    macropod, Aug 25, 2017
    #4
    Gillian Simpson likes this.
  5. Gillian Simpson

    Gillian Simpson

    Joined:
    Aug 22, 2017
    Messages:
    12
    Likes Received:
    0
    Yip got it right on my own ! Geez this is a whole new learning curve but loving it!
     
    Gillian Simpson, Aug 25, 2017
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. buckeyegator

    File formats Word2007 & Word 2010

    buckeyegator, Jun 3, 2011, in forum: Word
    Replies:
    0
    Views:
    545
    buckeyegator
    Jun 3, 2011
  2. Judith
    Replies:
    1
    Views:
    693
    macropod
    Mar 2, 2012
  3. kate12402
    Replies:
    0
    Views:
    622
    kate12402
    Jun 10, 2014
  4. Marsha B
    Replies:
    1
    Views:
    128
    macropod
    Jan 1, 2017
  5. Ronnie2520

    How do I post date a letter?

    Ronnie2520, Jan 12, 2017, in forum: Word
    Replies:
    1
    Views:
    184
    macropod
    Jan 13, 2017
  6. ArieK
    Replies:
    2
    Views:
    186
    macropod
    Mar 31, 2017
Loading...