Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Re:Over-ride automatic subscripting (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Over-ride automatic subscripting
#25
JohnDoyle ()
Please support us with an XLC Pro Subscription.
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Over-ride automatic subscripting 1 Year, 9 Months ago Karma: 470  
When an equation is 'named' they are forced to end with the two character " =". Then XLC knows that it is a named cell and it will enforce automatic subscripting. Automatic subscripting forces all characters after the first character to be subscripted. Automatic subscripting is very important particularly if you remove multiplication signs in equations failure to use automatic subscripting could produce ambiguous equations.
I can see in your case that q" could be useful and I suggest you use the following work-around. Enter 'q"=' into the cell (make sure that it is not 'q" =' i.e. missing the space character). Then the cell will not be automatically subscripted.
I may have laboured the point here - delete the space character before the equals character and it will never again be automatically subscripted.
 
Report to moderator   Logged Logged  
 
  The administrator has disabled public write access.
      Topics Author Date
    emo
Over-ride automatic subscripting
Helen_Miller 2007/02/07 15:01
    thread link
thread linkthread link Re:Over-ride automatic subscripting
BoJosley 2007/02/07 15:37
    emo
thread linkthread link Re:Over-ride automatic subscripting
Helen_Miller 2007/02/08 09:44
Go to top Post Reply