HI i am unable to give superscript in formula.

  • Thread starter Thread starter Ganesh
  • Start date Start date
G

Ganesh

HI sir/madam
This is ganesh from singapore need some small help from you
In formula bar i am unable to give any superscript or subscript
Briefly explaining my problem
i want the result in mm2 or inch2 (Area Units)
but it was not giving properly if i use in formula bar
i know normal formating but i wanted in formula result
kindly guide me in this regard
Ganesh
 
You can only use this kind of character formatting for text values -- not
formulas and not real numbers.

So if the cell really contains a formula, you can't have one character formatted
like this.

If the value in the cell is really text, then you should be able to see the
superscript/subscript reflected in the cell--not in the formulabar.

Just select the character(s) you want superscripted or subscripted, rightclick
on that selection and choose format cells.

Then check the superscript or subscript box.
 
HI sir/madam
This is ganesh from singapore need some small help from you
In formula bar i am unable to give any superscript or subscript
Briefly explaining my problem
i want the result in mm2 or inch2 (Area Units)
but it was not giving properly if i use in formula bar
i know normal formating but i wanted in formula result
kindly guide me in this regard
Ganesh
Click to expand...

This might do what you want.

Custom format the cell:

Format/Cells/Number/Custom
Type: 0.00" mm²"
or
0.00" in²"

The superscripted 2 is entered by holding down the <alt> key and while typing
0178 on the Numeric Keypad. Then release the <alt> key.

Be sure to use the numeric keypad and not the number keys at the top of the
regular keyboard.
--ron
 
Most fonts have a character superscript 2 or 3. For example, Arial is
CHAR(178), so you could write it such as =... "mm"&CHAR(178)
 
Back
Top