Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
g999999 g999999 is offline
external usenet poster
 
Posts: 1
Default my excel dates show as numbers when mailmerged

dates in my excel work book show as numbers or american format dates when i
mailmerge documents.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default my excel dates show as numbers when mailmerged

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/formatting_word_fields.htm

or

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002/2003" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindy...r/MergFram.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"g999999" wrote in message
...
dates in my excel work book show as numbers or american format dates when
i
mailmerge documents.


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
mail merge shows numbers for dates jim Mailmerge 0 December 19th 08 02:18 AM
Images MailMerged from Excel jbrzez Mailmerge 3 January 30th 07 07:19 PM
page numbers show on screen; field codes show when printed Julie M Page Layout 1 August 3rd 06 07:17 PM
ADDRESS NUMBERS SHOW AS 0 WHEN MAIL MERGING FROM EXCEL DeanH Mailmerge 1 June 6th 05 09:12 PM
Word 2003 Merged Dates show time after date Emmy Microsoft Word Help 1 April 19th 05 07:06 PM


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