How to print only month and day of a date into a merged Word docum
 

Please help! I have the date of birth column formated as m/d. But if I
don't enter a year, excel automatically enters one. Then, when I merge the
DOB info into my Word document, the year is inserted. I don't want the
year--only the month and day to be displayed. How can I fix this vexing
problem?

How to print only month and day of a date into a merged Word docum
 

If you don't want a year, then you don't want an Excel date. Put the data
in as text, either by formatting the cells as text before you put the data
in, or by preceding the data with an apostrophe.
Another option if you are trying to merge stuff into Word but allowing you
to use Excel dates is to use a helper column derived from the date but
converting it to text, something like =TEXT(A1,"m/d")
--
David Biddulph

"ZatHope" wrote in message
...
Please help! I have the date of birth column formated as m/d. But if I
don't enter a year, excel automatically enters one. Then, when I merge
the
DOB info into my Word document, the year is inserted. I don't want the
year--only the month and day to be displayed. How can I fix this vexing
problem?