View Single Post
  #5  
Old February 9th, 2009, 06:15 AM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default formatting dates

Specifically { MERGEFIELD BdayA1 \@ "MMMM d" }
Press F9 to update the field and ALT+F9 to toggle the display back again.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Suzanne S. Barnhill wrote:
You press Alt+F9 to display the field code of your merge field (such
as «BdayA1», which will show { MERGEFIELD BdayA1 }) and add the
switch to that field.


"Wiersma7" wrote in message
...
The table has merge fields from an Excel spreadsheet. I understand
the premise of what the [below address: http:
//www.gmayor.com/formatting_word_fields.htm] is about - but I'm not
sure how to incorporate that into my table. Do I add the switch as a
field to the spreadsheet? To the table? That doesn't seem to work. I
guess I'm asking if you can simplify it for me. I would like to
change the format of 01/01/09 to January 1. (btw - I do know how to
do it in Excel ) Also, is there way to have a conditional rule (?) to
only print the
text: 'Birthday:' if there is a date in the date field?
Below is the simple table (obviously I'm making a directory - for my
church):

«Adult1»
Birthday:
«BdayA1»

Cell:
«CellA1»

Email:
«EmailA1»

Anniversary:
«Anniversary»





Thanks very much for your help so far,
wiersma7


"Suzanne S. Barnhill" wrote in message
...
If the table was created via a mail merge, you can add a numeric
picture switch to the merge field to constrain the display (see
http://www.gmayor.com/formatting_word_fields.htm). Alternatively,
you can link to Excel using DDE instead of OLE DB, which will
preserve the native Excel formatting.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Wiersma7" wrote in message
...
I have a table that has birthday dates. The info in the table was
imported from Excel with the dates formatted as 'mmmm dd'.
However, they imported as I entered them: mm/dd/yy. I don't want
the years to show. How can I format these dates in my table to
reflect only the Birth Date? (rather than going through each
record) Thanks,
wiersma7