| 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 |
| 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) | |||
Threaded Mode
