I have everyone's start date in a column. I'd like to create another column
with their start date in text so that I can then use it in a mail merge for
their certificates. I've got it converted but the MM/DD/YYYY is behind the
scenes and when I do the merge that comes over versus Month Day, Year.

Any help?

You can do the formatting Word but in ahelper column

=TEXT(A1,"mmmm dd") adjust what's in the quotes to suit.


Gord Dibben MS Excel MVP

On Wed, 21 Apr 2010 15:31:03 -0700, Erinayn
wrote:

I have everyone's start date in a column. I'd like to create another column
with their start date in text so that I can then use it in a mail merge for
their certificates. I've got it converted but the MM/DD/YYYY is behind the
scenes and when I do the merge that comes over versus Month Day, Year.

Any help?

You can use field codes to do this without having an additional column in
your worksheet. If you insert a Date field into the main document and then
press ALT+F9, you see as below

{ MERGEFIELD "Date" }

To get all the dates in the merged documents to have a format you want; you
can add this formatting switch to the field code:

To display as January 1, 2010 try

{ MERGEFIELD "Date" \@ "MMMM d, yyyy" }


--
Jacob (MVP - Excel)


"Erinayn" wrote:

I have everyone's start date in a column. I'd like to create another column
with their start date in text so that I can then use it in a mail merge for
their certificates. I've got it converted but the MM/DD/YYYY is behind the
scenes and when I do the merge that comes over versus Month Day, Year.

Any help?

Forgot to mention; this query should have been posted in 'Word discussion
groups'..

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

You can use field codes to do this without having an additional column in
your worksheet. If you insert a Date field into the main document and then
press ALT+F9, you see as below

{ MERGEFIELD "Date" }

To get all the dates in the merged documents to have a format you want; you
can add this formatting switch to the field code:

To display as January 1, 2010 try

{ MERGEFIELD "Date" \@ "MMMM d, yyyy" }


--
Jacob (MVP - Excel)


"Erinayn" wrote:

I have everyone's start date in a column. I'd like to create another column
with their start date in text so that I can then use it in a mail merge for
their certificates. I've got it converted but the MM/DD/YYYY is behind the
scenes and when I do the merge that comes over versus Month Day, Year.

Any help?