=UPPER(TEXT(A1,"MMMM d, yyyy")) and copy down and COPY PASTESPECIAL
VALUES on the column..........."but" they are now TEXT, no longer dates as
far as Excel is concerned.

Vaya con Dios,
Chuck, CABGx3




"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!