|
to express degrees & power of a number in excel
How can i express 'degrees' & power of any number in excel
Thank you, K.S.Warrier |
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 On Fri, 5 Nov 2004 07:52:04 -0800, "K.S.Warrier" wrote: How can i express 'degrees' & power of any number in excel Thank you, K.S.Warrier |
Thanks a lot.
K.S.Warrier "Gord Dibben" wrote: 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 On Fri, 5 Nov 2004 07:52:04 -0800, "K.S.Warrier" wrote: How can i express 'degrees' & power of any number in excel Thank you, 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 "K.S.Warrier" wrote: Thanks a lot. K.S.Warrier "Gord Dibben" wrote: 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 On Fri, 5 Nov 2004 07:52:04 -0800, "K.S.Warrier" wrote: How can i express 'degrees' & power of any number in excel Thank you, K.S.Warrier |
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 On Sat, 6 Nov 2004 09:12:03 -0800, "K.S.Warrier" wrote: 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 "K.S.Warrier" wrote: Thanks a lot. K.S.Warrier "Gord Dibben" wrote: 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 On Fri, 5 Nov 2004 07:52:04 -0800, "K.S.Warrier" wrote: How can i express 'degrees' & power of any number in excel Thank you, 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 "Gord Dibben" wrote: 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 On Sat, 6 Nov 2004 09:12:03 -0800, "K.S.Warrier" wrote: 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 "K.S.Warrier" wrote: Thanks a lot. K.S.Warrier "Gord Dibben" wrote: 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 On Fri, 5 Nov 2004 07:52:04 -0800, "K.S.Warrier" wrote: How can i express 'degrees' & power of any number in excel Thank you, 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 "K.S.Warrier" wrote: 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 "Gord Dibben" wrote: 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 On Sat, 6 Nov 2004 09:12:03 -0800, "K.S.Warrier" wrote: 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 "K.S.Warrier" wrote: Thanks a lot. K.S.Warrier "Gord Dibben" wrote: 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 On Fri, 5 Nov 2004 07:52:04 -0800, "K.S.Warrier" wrote: How can i express 'degrees' & power of any number in excel Thank you, K.S.Warrier |
| All times are GMT +1. The time now is 10:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com