Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
christina_b123 christina_b123 is offline
external usenet poster
 
Posts: 1
Default Mail merging a date from excel, appears as US format not UK

I have been mail merging a letter in word, but no matter how I format the
cells in Excel, the date field appears in the US format, and I need it in the
UK style.

Can anyone help?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Mail merging a date from excel, appears as US format not UK

Hi Christina,

You can get the date to display correctly by editing the mailmerge field in Word. To do this, select the errant field and press
Shift-F9. It sould look like '{MERGEFIELD ExcelDate}'. Add a picture switch to the field, thus: '{MERGEFIELD ExcelDate \@ "d MMM
yyyy"}', then press F9 to update the field. You will now have dates appearing as '15 Nov 2008'. Other date switch options include:
\@ "dd/MM/yyyy" for 15/11/2008
\@ "dddd, d MMMM yyyy" for Thursday, 15 November 2008
and so on. Basically, the switch parameters do the same as in Excel, See Word's help file on field switches for more info.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"christina_b123" wrote in message
...
I have been mail merging a letter in word, but no matter how I format the
cells in Excel, the date field appears in the US format, and I need it in the
UK style.

Can anyone help?


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
Merging Excel to word. How to stop Date changing into US format. Jackieblue Mailmerge 1 October 1st 07 09:32 PM
mail merging date fields from excel pama Mailmerge 5 November 21st 06 04:35 PM
HELP!!! Date not in correct UK format when merging from Excel Mike, Lancaster, UK Mailmerge 1 October 12th 05 02:30 PM
Excel date format merging to Word XP version Linda - Xtremly Peeved Mailmerge 11 April 12th 05 06:50 AM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 07:34 AM


All times are GMT +1. The time now is 07:59 AM.

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"