Thanks, but I can not use a formula in the cell. The users will be typing the
date directly into the cell.

I need to know whether (From MENU bar) Format/Cells/Number/Custom be used to
make a date show the month name in all caps?


"Teethless mama" wrote:

Try this:

=UPPER(TEXT(A1,"mmmm"))



"TOMB" wrote:

Can Format/Cells/Number/Custom be used to make a date show the month name in
all caps?

I am using an HLOOKUP to drive several report fields which are based on the
first day of a month.

Rather than show the date in the mm/dd/yyyy format, I have formated the cell
for mmmm which shows the date with the full month name formated as 'Proper'.
I would like to show the month name in all caps.

Current: A1 = 1/1/2006; Format displays as January - (Proper)
Would like: A1 = 1/1/2006, Format to display JANUARY - (All Caps)

Can not use a formula as users need to type the date in the cell in order to
create different scenarios.

Thanks in advance!

- - TomB - -