| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't change formula to lowercase?
I have a spreadsheet with DDE links in it & for some reason I can't edit the
formula to change Uppercase to Lowercase. (ie. trying to change Downtime to downtime). It accepts the change when I edit it, but when I hit enter & move off the cell it changes back to Uppercase??? FORMULA =(CDMDDE|'C:\Program Files\OMRON\CX-Server\lori.cdm'!\Downtime\MonthYear) Help!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't change formula to lowercase?
It's all to do with how the DDE functions were first defined by the addin
providing the functions. Not much you can do about it unless you can get into the addin, delete the ucase function name then retype it how you want it in lcase. -- Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "L Buchy" wrote in message ... I have a spreadsheet with DDE links in it & for some reason I can't edit the formula to change Uppercase to Lowercase. (ie. trying to change Downtime to downtime). It accepts the change when I edit it, but when I hit enter & move off the cell it changes back to Uppercase??? FORMULA =(CDMDDE|'C:\Program Files\OMRON\CX-Server\lori.cdm'!\Downtime\MonthYear) Help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel , is there a way i can change UPPERCASE to lowercase? | Excel Discussion (Misc queries) | |||
| In Excel, can you change uppercase letters to lowercase | New Users to Excel | |||
| change capitalize letters to lowercase | Excel Discussion (Misc queries) | |||
| Is there a way to change Lowercase or Proper to ALL CAPS? | Excel Worksheet Functions | |||
| How do I do a global change from uppercase to lowercase? | Excel Discussion (Misc queries) | |||
Hybrid Mode
