The all caps date is for display, right? Make one table for display, and
somewhere else have a table that Excel can use for calculations. The extra
cells you need are cheap, especially compared to the effort it would take to
force one cell to fulfill two contradictory roles.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


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