You have a cell (A1, say) with a date and you format it to show the name of
the month in proper case. But you want all capitals?
What has this to do with HLOOKUP?
If A1 displays Nov and F1:Q1 have: Jan, Feb,....Nov, Dec then
=VLOOKUP(MONTH(A1),E1:Q1,2,FALSE) is NOT going to result in Nov. You are
still passing a date with the reference to A1 no matter what it displays.
How about =INDEX(F1:Q1,MONTH(A1)) ? This will return Nov. The method can be
expanded to tables with more than 1 dimension.
Hope this makes sense to you.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"TOMB" wrote in message
...
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 - -