#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
********Meg ********Meg is offline
external usenet poster
 
Posts: 12
Default date formatting

I have my datasource in excel and I want to have a date format that only
gives the month and day, no year. It is formatting correctly in excel, but
when I do a mail merge to word, it actually puts in the year and for that
matter is putting in 200, which in this case is wrong..it would be 2008.
How can I either get rid of the year altogether or at least make it so that
it is 2008?


Thanks
this is office 2003 on a windows xp system.
--
Meg


  #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 date formatting

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

http://www.gmayor.com/formatting_word_fields.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

"********Meg" wrote in message
...
I have my datasource in excel and I want to have a date format that only
gives the month and day, no year. It is formatting correctly in excel, but
when I do a mail merge to word, it actually puts in the year and for that
matter is putting in 200, which in this case is wrong..it would be 2008.
How can I either get rid of the year altogether or at least make it so that
it is 2008?


Thanks
this is office 2003 on a windows xp system.
--
Meg



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
Date formatting B.W. New Users 3 September 16th 06 07:56 AM
Formatting Date in Merge swimdad16 Mailmerge 1 May 23rd 06 05:58 PM
Date Formatting Kushum Mailmerge 3 August 31st 05 07:41 PM
long date formatting in access shows as short date in word farley Mailmerge 3 August 16th 05 04:45 AM
Date Field Formatting Goose040 Microsoft Word Help 3 April 29th 05 06:07 PM


All times are GMT +1. The time now is 08:25 AM.

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"