Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
catherine
 
Posts: n/a
Default UK dating in date-time picture field

I have an Excel spreadsheet formatted to UK dating (5 April 2006) but in a
mailmerge the date is read the US way and appears 4 May 2006. How can I
change this?. My picture field switch in the Word document reads "dd MMMM
yyyy" and my Excel column is "[$-809]dd mmmm yyyy;@". I have tried copying
the Excel formula into a date-time picture field switch without success.
 
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
Convert Date Field to Text Cardlaw Microsoft Word Help 8 February 9th 06 11:17 AM
how do i set a reacuring date on a document? welker_daniel New Users 4 October 29th 05 08:38 AM
keyboard shortcut for create date & time chixwchops Microsoft Word Help 4 September 14th 05 07:42 PM
Link Merge Fields in Header and Footer jeanmac Microsoft Word Help 9 September 12th 05 10:50 PM
Manually edit date in createdate field Graham Mayor Microsoft Word Help 2 August 27th 05 08:23 AM


All times are GMT +1. The time now is 06:18 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"