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?