Maybe use two columns, one with the TEXT date the way you want to see it,
and another with the real Excel date to manipulate as you wish as a
date...........

hth
Vaya con Dios,
Chuck, CABGx3


"lamersn" wrote in message
...
Thanks though- I already have the date in the cell I used the formula from
CLR on- was looking for something that would show the date with the month
in
caps and still be recognized by Excel as a date~



"Mike Campbell" wrote:

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!