Formating - Date as Month In All Caps

T

TOMB

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

Niek Otten

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

Why not use an extra cell; one to accept user input, one to show how your system interpreted that. Use UPPER() and TEXT() in that
last cell.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

TOMB

Space is an issue, but I think I will have to do just that. I thought I'd see
if other options were available. Sort of like using
Format/Cells/Number/Custom to change the way a negative number is Formated -
-i.e.[RED]

Thanks for the follow up though!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top