How to add exponents in Excel 2016?

[Diddums x]

Need a quick answer hence posting here. I need to add Exponents in Excel, namely 10^2 to 10^7. Not a mathematical purpose, but the actual symbol. Anyone know how to do this?

Ta

 

[Diddums x]

Can you not just write is using the ^?

Every chance i'm missing what you want!

No, my (weak) google fu came up with this too, doesn't work. Would've made my life so much easier!

 

[Diddums x]

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