Date Format - month Upper case

[Stuart H]

How do you format a cell to show the date as
13 MARCH 2004 (i.e. where the month is in UPPER case)?
Many thanks in advance.

 

[Govind]

Hi Stuart,

Try

=SUBSTITUTE(TEXT(A1,"dd.MMM.yy"),TEXT(A1,"MMM"),UPPER(TEXT(A1,"MMM")))

Change the time format as you wish.

Regards

Govind.

 

[Stuart H]

Govind
Your suggestion worked a treat - Many thanks.

 

[Govind]

Thanks for the feedback Stuart.

Govind.

Govind
Your suggestion worked a treat - Many thanks.

 

[JE McGimpsey]

Or, a bit simpler:

=UPPER(TEXT(A1,"dd MMMM yy")