| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
UPPER
Try this:
=UPPER(TEXT(A1,"MMM")) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
UPPER
Thank you. That works perfectly! Connie
"porter444" wrote: Try this: =UPPER(TEXT(A1,"MMM")) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert lower to upper case automatically without using UPPER | Excel Discussion (Misc queries) | |||
| Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
| Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
| How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) | |||
Linear Mode
