Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rhianne Rhianne is offline
external usenet poster
 
Posts: 9
Default Date changes format after being merged from Data Source to Documen

Why is it that when attempting to merge information from my data source
(excel), that the date format changes in the merging document (word).

In the excel spreadsheet the column for dates has been formatted to show
e.g. 12 February 2009, but once merged the date shows as 02/12/09 - which
incidentially is the Amercian way of depicting the date, nothing wrong with
that but in the UK it would be too confusing!

I have tried formatting excel again and merging again but it does not seem
to work. What is the problem and how can I rectify it?

Many thanks

Rhianne
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The date in a merged word doc is US format source is UK format Cogito Mailmerge 4 March 12th 08 01:28 PM
Date fields are merged incorrectly when I use an Excel data source Jemdlee Mailmerge 4 May 30th 07 12:56 PM
Not all the data from my data source appears in my merged documen Marseldav Mailmerge 0 May 29th 07 05:13 PM
how to keep date format in merged document same as in data source clivedaniels Microsoft Word Help 1 October 5th 06 06:52 AM
word changes merged access data 'date' format from d/m/y to m/d/y Rotor-blade Mailmerge 1 February 11th 06 05:58 PM


All times are GMT +1. The time now is 01:33 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"