D
DerbyDad03
Greetings!
I know Excel pretty well, but Word is a mystery to me.
I'm trying to bring dates from Excel into a Word doc via Mail Merge.
I have column of dates that might read as follows:
Date Received
1/28/2010
2/15/2010
2/18/2010
This works fine via Mail Merge and the dates show up as dates.
However, if I enter text anywhere in this list, Mail Merge converts
the dates to the serial numbers that Excel uses to store dates. For
example, if I have this:
Date Received
1/28/2010
Pending
2/18/2010
I'll get 40206 for 1/28/2010, Pending for Pending, 40227 for
2/18/2010, etc.
If I remove Pending (or "n/a" or any other text) the dates revert back
to the date format shown in Excel.
Is there a way around this - other than forcing the dates in Excel to
be text, which creates a different set of issues in the spreadsheet?
Thanks!
I know Excel pretty well, but Word is a mystery to me.
I'm trying to bring dates from Excel into a Word doc via Mail Merge.
I have column of dates that might read as follows:
Date Received
1/28/2010
2/15/2010
2/18/2010
This works fine via Mail Merge and the dates show up as dates.
However, if I enter text anywhere in this list, Mail Merge converts
the dates to the serial numbers that Excel uses to store dates. For
example, if I have this:
Date Received
1/28/2010
Pending
2/18/2010
I'll get 40206 for 1/28/2010, Pending for Pending, 40227 for
2/18/2010, etc.
If I remove Pending (or "n/a" or any other text) the dates revert back
to the date format shown in Excel.
Is there a way around this - other than forcing the dates in Excel to
be text, which creates a different set of issues in the spreadsheet?
Thanks!