Try a helper column =TEXT(A1,"mmmm d yyyy")
--
David Biddulph

wrote in message
oups.com...
I reformatted a date range (I had trouble doing this at first- the
date did not appear to reformat. I took someone's advice and replaced
all the spaces with spaces as described only slightly less confusingly
on this web page:
http://en.allexperts.com/q/Excel-1059/Date-Format.htm

and after that the date appeared correctly.) Now, however, I'm trying
to do a merge into another program, but the date appears in a
different format altogether.

Originally: 8 June 2007
After Reformatting: June 8 2007
After Merge: 06/08/07

Any thoughts?