DATE CUSTOM FORMAT

  • Thread starter Thread starter JON-JON
  • Start date Start date
J

JON-JON

Hello,

When I format date 1/31/03 as mmmm or even MMMM the result is January but
I want it all to be in Ucase as JANUARY. How can I do it?

TIA

Jon-jon
 
JON-JON,

Only way I can see you getting that is by formula -

=UPPER(TEXT(A2,"mmmm"))

regards,

JohnI
 
Back
Top