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
#22
Over-ride automatic subscripting 1 Year, 8 Months ago Karma: 13  
Is there anyway to over-ride automatic subscripting when equations are named. I want to have a equation name of q" for a heat transfer calculation and the " character is always being subscripted. Thanks for any help.<br><br>Post edited by: Helen_Miller, at: 2007/02/16 14:21
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#25
Re:Over-ride automatic subscripting 1 Year, 8 Months ago Karma: 471  
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.
#27
Re:Over-ride automatic subscripting 1 Year, 8 Months ago Karma: 13  
Thanks Bo your work around does the trick for me.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply