I cannot get a variable name to start with more than one non-sub-scripted letter.
The variable name I want is "OAT" for outdoor air temperature.
I entered the following into excel and clicked the name equation button:
OAT
OAT=
OAT =

In every case the "A" is subscripted. I want the A and the T to not be subscripted.

I tried the "COST1=" example from the forum.
Nothing is working.
How do I get a variable name of multiple characters with no subscripting?

I read the following posts. I watched some videos. The videos stopped playing on my PC. Only the Quick start video will play and it doesn't cover my problem. The naming variables video won't play. I tried playing them on my Mac and it asks me to buy a plug in called flip4Mac. I searched some on youtube but didn't find the specific video.

#2 JohnDoyle 2010-10-18 11:06
You might want to see the XLC video tutorial series.

Re:Naming variables 7 Months, 4 Weeks ago Karma: 477 Karma+ Karma-
The default behaviours ensures that there is no confusion when multiplication signs are removed. If you do not wish enforce this naming convention (e.g. if you would like equations to read like PRICE = QUANTITY x TIME) you may end the Named Cell with just a single "=" character rather than the usual two " =" characters. You should also set the EQS() parameter "Multiplication= 1" so that multiplication signs are always shown.

E.g. XLC will enforce automatic subscripting of a cell named "A1 =" because there is a space before the final "=" character; XLC will ignore the formatting of an unconventionally named cell like"COST1=" which will be drawn into equations with this formatting because there is not a space before the final "=" character.

Read more here: www.excelcalcs.com/xlc/xlc-help-and-tutorials/name-equations/

Here are some examples that I hope will help:

Make sure the "Auto XLC" Switch is on then enter the following into a cell:
OAT =
O_AT=
O_A_T=
O_A^T=

You should see the following:


I hope this helps

Thanks, but I want the variable to look like this:
OAT =
with no sub-scripting or super-scripting.
Your example of "COST1 =" indicates it is possible.
Each of your examples in the reply contains sub-scripting and/or super-scripting.
I want a variable name with no sub-scripting or super-scripting.
Is this possible?
Thanks

OK just type in
OAT=
to produce what you are after. This is different to entering
OAT =
which will give you automatic subscripts (what a difference a " " makes)