UPPER

C

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
 
C

chavan2000 via OfficeKB.com

Connie said:
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
Click to expand...

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

Shane Devenshire

Hi Chavan,

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

Cheers,
Shane Devenshire
 
Top