View Single Post
  #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.