Excel - Stopping excel 'correcting' the case of a formula variable

[garybug]

I have the following formula in an Excel cell-

=REUTER|IDN!'GBPAM3L15M=ICAP,SECOND ACTIVY 1'

which returns data from a Reuters add-in, but I mistakenly typed the GBPAM3L as GBPam3L, and now whenever I try to correct it by changing the 'am' to 'AM', Excel 'helpfully' changes it back to 'am'. It is driving me round the bend, as I can't seem to find any autocorrect / fill / replace option. HELP!!

Ta much

Gaz

 

[01Patrik]

Tools...options...spellings tab - options for autocorrect (or something like that) button.

(At least in XP and 2003, don't know about 2K)


// Patrik

 

[AnotherHiggins]

In 2000, it's Tools>Auto Correct...

John

Every generalization is false, including this one.

 

[garybug]

I've played with all of these, but still no joy. :-(

 

[DaleWatson123321]

Hi,

I thought I'd take a stab at this. In "playing around" with different options, I managed to create the formula as you require it - i.e. with the "am".

Problem now is, I can't re-create the steps I used.

It IS a formula - i.e. it's NOT entered as text.

Hope this can work for you.

Regards, Dale Watson

 

[SkipVought]

If it's a formula variable, look in Insert/Name/Define

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]