UPPER
 

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

UPPER
 

Try this:

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

UPPER
 

Connie Martin wrote:
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.

--
Message posted via http://www.officekb.com

UPPER
 

Thank you. That works perfectly! Connie

"porter444" wrote:

Try this:

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

UPPER
 

Hi Chavan,

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

Cheers,
Shane Devenshire

"chavan2000 via OfficeKB.com" wrote:

Connie Martin wrote:
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.

--
Message posted via http://www.officekb.com