Can't change formula to lowercase?

L

L Buchy

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!!
 
R

Robin Hammond

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top