K
K.S.Warrier
How can i express 'degrees' & power of any number in excel
Thank you,
K.S.Warrier
Thank you,
K.S.Warrier
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
By "express" do you mean like 98º (degrees)
And 5² or 10³ ??
degrees is ALT + 0186
subscript 2 is ALT + 0178
subscript 3 is ALT + 0179
Others would have to be manually formatted as Subscript.
If not what you are looking for, post back or wait for other guesses.
Gord Dibben Excel MVP
And 5² or 10³ ??
degrees is ALT + 0186
subscript 2 is ALT + 0178
subscript 3 is ALT + 0179
Others would have to be manually formatted as Subscript.
If not what you are looking for, post back or wait for other guesses.
Gord Dibben Excel MVP
K
K.S.Warrier
Thanks a lot.
K.S.Warrier
K.S.Warrier
Gord Dibben said:By "express" do you mean like 98º (degrees)
And 5² or 10³ ??
degrees is ALT + 0186
subscript 2 is ALT + 0178
subscript 3 is ALT + 0179
Others would have to be manually formatted as Subscript.
If not what you are looking for, post back or wait for other guesses.
Gord Dibben Excel MVP
K
K.S.Warrier
Alt+0186 ,alt+0178,alt+0179 are not giving the degrees, subscript 2,subscript
3 resply.What you meant is correct regarding the expression I
intended.Whether there is difference in unicode in new version(XP),2003,2000
etc.Any more information on this.
Thanks
K.S.Warrier
3 resply.What you meant is correct regarding the expression I
intended.Whether there is difference in unicode in new version(XP),2003,2000
etc.Any more information on this.
Thanks
K.S.Warrier
G
Gord Dibben
KS
You must enter the 0179 etc. using the NumPad on the right-side of keyboard,
NOT the number keys above qwerty.
I missed that point in my first post. Sorry about that.
For a better degrees symbol I would suggest ALT + 0176
And for the heck of it......
Sub Squared()
Selection.NumberFormat = "#,##0²"
End Sub
Sub Cubed()
Selection.NumberFormat = "#,##0³"
End Sub
Sub degrees()
Selection.NumberFormat = "#,###°"
End Sub
Gord
You must enter the 0179 etc. using the NumPad on the right-side of keyboard,
NOT the number keys above qwerty.
I missed that point in my first post. Sorry about that.
For a better degrees symbol I would suggest ALT + 0176
And for the heck of it......
Sub Squared()
Selection.NumberFormat = "#,##0²"
End Sub
Sub Cubed()
Selection.NumberFormat = "#,##0³"
End Sub
Sub degrees()
Selection.NumberFormat = "#,###°"
End Sub
Gord
K
K.S.Warrier
Hi Gord,
I have put '+' sign also after ALT as I was doing for some charactor
unicode.When I tried without '+' sign ,it worked.Thank you very much.
K.S.W
I have put '+' sign also after ALT as I was doing for some charactor
unicode.When I tried without '+' sign ,it worked.Thank you very much.
K.S.W
K
K.S.Warrier
Hi,
Again ,on verifying , 90° is displayed here by ALT+ 0176 & ALT+ 0186,but in
excel cell,some other symbol is seen.Similarly, for showing as power of a
number,the symbol is not displayed in the cell eventhough on the function
tab,it is shown correctly.Without the symbol it can be done as 5^2 =25(=5²).
Thank you,
KSW
Again ,on verifying , 90° is displayed here by ALT+ 0176 & ALT+ 0186,but in
excel cell,some other symbol is seen.Similarly, for showing as power of a
number,the symbol is not displayed in the cell eventhough on the function
tab,it is shown correctly.Without the symbol it can be done as 5^2 =25(=5²).
Thank you,
KSW