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