How to add exponents in Excel 2016?
- Thread starter Diddums x
- Start date
Soldato
- Joined
- 12 Sep 2012
- Posts
- 11,698
- Location
- Surrey
Insert>Symbol>choose your symbol
It will probably set the cell to text or general format since it is a special character and therefore wont be recognised by excel as a maths formula
It will probably set the cell to text or general format since it is a special character and therefore wont be recognised by excel as a maths formula
Last edited:
No, my (weak) google fu came up with this too, doesn't work. Would've made my life so much easier!
Insert>Symbol>choose your symbol
It will probably set the cell to text or general format since it is a special character and therefore wont be recognised by excel as a maths formula
Yep, this is the one! Cheers, much appreciated
Associate
- Joined
- 23 Oct 2013
- Posts
- 1,248
not in front of Excel atm, but i think there's another way...
if you mean typing 10^2 auto changes to 100 then
right click on the cell -> formatting and change the cell's type to text. then type 10^2
or, if you want 10 with a 2 superscript (like 10²) then I think you can type 102, then f2 to edit, select just the 2 and right click -> formatting -> superscript.
if you mean typing 10^2 auto changes to 100 then
right click on the cell -> formatting and change the cell's type to text. then type 10^2
or, if you want 10 with a 2 superscript (like 10²) then I think you can type 102, then f2 to edit, select just the 2 and right click -> formatting -> superscript.