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