CheckEmoji Community · the emoji forum
🏠 Home 🆕 What's new ❓ Unanswered 🔥 Popular 📡 RSS Members 👥 0 online log in · register
Home › IT › Software › Excel 2003 exponent issue!

Excel 2003 exponent issue!

Started by William Wood75 · · 👁 2 views · 5 replies

📡 Subscribe to replies

Participants William Wood75Asilenteagle15Kyle Bennett2
William Wood75 William Wood75 MemberOP
11 messages
joined Sep 2007
#1 ·
Does anyone know how to type an exponent in xls 2003 ??

I’ve been poking around the standard ribbon and the formatting tools, but I can't find anything specifically for this. The only thing I've found is through the "Symbols" option under the "Insert" menu. I did manage to find a few things in those symbols that look like they might work as exponents, but there are only the numbers 1, 2, and 3—so what am I supposed to do if I need any other digits?
I've spent some time digging around, but I haven't figured out if there's a way to just insert a specific symbol to cover the numbers 4 through 9.

Any help would be much appreciated!
A Anonymous Veteran
3.6K messages
joined May 2005
#2 ·
Just click on the cell you want to use, head up to the formula bar, and type something like 2, then hold down AltGr and hit the 3 key, followed by the number you want to raise it to—say, 5... and that cell will spit out 32.

It would look like this: 2^5
William Wood75 William Wood75 MemberOP
11 messages
joined Sep 2007
#3 ·
Oh, great!👍 I didn't actually mean I wanted that—what I was going for was having a word or a label indexed with a number where the number sits up top as an exponent, rather than down low as a subscript. Hopefully, I’m making more sense now...🙂
For example, if I type "brrr5," I want that 5 to be a superscript!
silenteagle15 silenteagle15 Newcomer
8 messages
joined Jun 2007
#4 ·
So, here’s how it looks if you put this in cell A1:
brtz4

Then, if you type something like this into cell B1:
3

...what we’re actually looking for is 3^4...

So, for cell C1, you’d do this:
=POWER(B1,MID(A1,5,1))
The result should be 81!

Basically, you just need the power(base, exponent) function and mid(text, start_num, num_chars)
to get it done!
Kyle Bennett2 Kyle Bennett2 Newcomer
1 message
joined Dec 2007
#5 ·
So, you type out your text, brrr5, but don't hit Enter yet—just stay right there in the cell. If you already moved on, just double-click the cell again to get back into edit mode. Once you're in, just highlight that number "5," head over to the Cells -> format menu -> Cells, and check the box for superscript.

By the way, if you're using Calibri in Vista, it actually handles all those exponents and subscripts just fine. 😬
William Wood75 William Wood75 MemberOP
11 messages
joined Sep 2007
#6 ·
Kyle Bennett2 said:Just type out your text—say, "brrr5"—but stay in edit mode (don't hit Enter yet. If you already did, just double-click the cell again). Now, highlight just the number "5," head over to the Cells menu bar -> Cells... and check the box for superscript.

By the way, if you're using Calibri from Vista, it actually includes both exponents and subscripts built right in.😬

You're a lifesaver 👍 👍
thanks

You must log in or register to reply here.

Log in Register

🔗 Similar threads