Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Gil5563 Gil5563 is offline
external usenet poster
Posts: 1
Default UK Datefield in Excel reverts to US format when mail merging Word

Have had excel and word 2003 installed on my PC at my place of work. Do a lot
of mailmerges.
Everything OK except when I mail merge using a date field in the SS (not
using the "today's date" update on word, - which works fine) which reverses
my UK date to US date i.e 24/02/2010 to 02/24/2010. The date appears
normally in the excel spreadsheet - until it is merged. I have tried re
formatting the cells and I have checked all the settings and they appear to
be set for English Uk - so I don't know what else to do!!

Any ideas please?
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
My zip code format is lost when merging from Excel to Word... Roy Laws Microsoft Word Help 1 May 26th 21 09:31 PM
My zip code format is lost when merging from Excel to Word... Merging Zip Code Errors Microsoft Word Help 12 October 20th 09 09:46 PM
Merging from excel but the currency format changes on word! Lee Mailmerge 4 February 15th 08 01:50 PM
Mail merging a date from excel, appears as US format not UK christina_b123 Mailmerge 1 November 15th 07 09:57 AM
Format Excel data for merging in Word BW Mailmerge 1 January 21st 05 01:25 AM

All times are GMT +1. The time now is 02:49 PM.

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

About Us

"It's about Microsoft Word"