Can I format a date in all caps?

C

CLR

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

lamersn

This works great for today's date- actually I didn't explain quite right- can
I format so that whatever date I enter in the cell will show the month in all
caps?

thanks again~
 
L

lamersn

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

thanks again~
 
M

Mike Campbell

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
 
L

lamersn

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~
 
J

Jon Peltier

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
 
C

CLR

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
 
Top