Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel UPPER function
I have a workbook with multiple linked worksheets, where various cells are
linked to other worksheets. One work sheet has a date of format xx-January-xxxx which transfers to other worksheets within the workbook, but I wish to convert the date to upper case. Using the upper function on the second worksheet, the date transfers OK, but as numeric format. I have tried setting cell formats, but the date always transfers as a numeric value. Any suggestions? Thankyou |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel UPPER function
You could try this:
=UPPER(TEXT(A1,"dd-mmmm-yyyy")) where A1 contains the date. Note that this will give you a text result. Hope this helps. Pete On Aug 14, 3:44*pm, Neil wrote: I have a workbook with multiple linked worksheets, where various cells are linked to other worksheets. One work sheet has a date of format xx-January-xxxx which transfers to other worksheets within the workbook, but I wish to convert the date to upper case. Using the upper function on the second worksheet, the date transfers OK, but as numeric format. I have tried setting cell formats, but the date always transfers as a numeric value. Any suggestions? Thankyou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upper / Fill Series Function in Excel | Excel Discussion (Misc queries) | |||
UPPER text function | Excel Discussion (Misc queries) | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Help With The Upper Function | Excel Worksheet Functions | |||
UPPER Function | Excel Worksheet Functions |