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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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")
 
Back
Top