upper case dates in excel

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
how can i display the following date 1/2/2006 as JANUARY 2, 2006
??
is there formatting for capital letters in customized formats? MMMM gives me a January the same as mmmm.

thanks for your help!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,473
Office Version
  1. 365
Platform
  1. Windows
Kyle775

If you can use another cell, you could use
=UPPER(TEXT(A1,"mmmm d, yyyy"))
 

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
thats great thanks both of you! i needed the entire date not just the month in capitals... its all sorted now. thanks again... someone just asked me to make that change, thought i could get away with lower case.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,129
Members
412,305
Latest member
Mozz
Top