UPPER

[Connie Martin]

I would like to convert a column of months typed as "Jan", etc. to "JAN",
etc. When using the UPPER function, it converts it to a 5-digit number which
I understand a little what that is. But when I format it then to a date,
this is where the problem is. It will not change. It remains the 5-digit
number. What gives? Connie

 

[porter444]

Try this:

=UPPER(TEXT(A1,"MMM"))

 

[chavan2000 via OfficeKB.com]

I would like to convert a column of months typed as "Jan", etc. to "JAN",
etc. When using the UPPER function, it converts it to a 5-digit number which
I understand a little what that is. But when I format it then to a date,
this is where the problem is. It will not change. It remains the 5-digit
number. What gives? Connie

dont you the Upper function go in the format and create a costomise format.

 

[Connie Martin]

Thank you. That works perfectly! Connie

 

[Shane Devenshire]

Hi Chavan,

there is no custom format to display the date in upper case

Cheers,
Shane Devenshire