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

Z

ZatHope

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?
 
D

David Biddulph

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top