Alright guys, in excel I want the to use scientific notation, but I want numbers ie 100=1E2=1*10^2

Thanks in advance.

If I'm getting what you are trying to do... right click on the cells you want, go to Format Cells. Then on the column of options that appear, pick scientific. You then have options to pick the number of decimals you want.

Doesn't scientific only give you Eetc? I am trying to get 10^etc. Sorry, I just realized how poorly that was written.

Well, through messing around... if you do Format Cells>Number>Custom

Then click on the 0.00E+00 example... change that to

0.00"x10^"E+00 (with quotes) this gets you close... but you still have the E+... I'll update if i find a way to remove that. But there's somewhere to start for you.

*Edit* I found some fairly advanced ways to use Visual Basic to perhaps do a really rough hack depending on the range of values you are expecting. If you can find a way to supress the output of having E+ in the Custom field then that would make it infinitely easier. Let me know how important this is and how hard you're willing to work.