Upper and Lower Case "within" a formula
=AQs or =AQS are not formulas and will return the #NAME? error.
Can you provide more detail or another example of a similar formula?
If you are just typing AQS and it changes to AQs maybe you have an Autocorrect
option.
I type AQs and Excel changes to Aqs due to Autocorrect "Correct 2 INitial
Capitals"
Gord Dibben MS Excel MVP
On Thu, 10 Jan 2008 14:10:02 -0800, Kevin
wrote:
I noticed with I type a formula (keep in mind this was orginal for a Reuters
Link) that depending upon which case the initial entry is made it can never
be changed. For example, type =AQs, then erase it and try to type =AQS;
excel autmatically changes the formula back to =AQs. This becomes
problamatice when entering Reuters function because some securities must be
Capitalized for Reuters to recongnize. Anyway to change this
|