View Single Post
  #1   Report Post  
Marisa
 
Posts: n/a
Default How do I change the date format to a long date after merging it

I have an Excel spreadsheet which I use for date input, I then import this
into Access database. Now I am trying to merge certain query info into a Word
document. However, the date format comes in as the US type (mm/dd/yyyy). I
have checked that it is in long date format in both Excel and Access but it
still displays incorrectly when I insert the merged field. Is there a way to
get the date to display as long format (30 October 2005 instead of
10/30/2005)?