That formula gives #VALUE, if A1 contains text.
--
David Biddulph

"Mike Campbell" wrote in message
...
Excel can convert date text to system dates. Try this:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Where Cell A1 contains the text MARCH 17, 2007

"lamersn" wrote:

So...does this mean there's no way to do it so that Excel still
recognizes it
as a date?

thanks again~

"CLR" wrote:

=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!