Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a dialog box to pop up when logging out of a docum | Excel Discussion (Misc queries) | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
How can i add a print-and save-date field in Excel as in Word? | Excel Worksheet Functions | |||
How can i add a print-and save-date field in Excel as in Word? | Excel Discussion (Misc queries) |