No problem. I just chalk it up to magic. (a very big category!)

allan wrote:

I don't have good enough a connection with the spreadsheet's source to find
out what they did, but I wasn't able to identify anything on my own (i.e., it
wasn't a special font or anything). Sorry.

"Dave Peterson" wrote:

Thanks for posting back.

If you find out what they did, post back (I don't have a guess).

allan wrote:

Dave, sorry about all the trouble. I was using data that someone else had
sent to me and I was modifying into financial statements. I'm not sure
exactly what formatting they had applied to the affected cells, but I did
(edit, clear, format) and I was able to do superscripts again. Thanks so
much for your help!

"Dave Peterson" wrote:

What's in the cell?

What character in that string are you trying to make a superscript?

What font are you using (for all the string or for that character)?

What version of excel are you using?

I've never had any trouble with plain old text (but that doesn't help you).

allan wrote:

I hit enter and it went to being "non-superscript," even though it appears as
superscript in the edit mode. I am trying to do this with text. The format
cells window show it as being formatted with a square or circle, rather than
the checkmark when I look at the particular cell. Thank you for the advice.

"Dave Peterson" wrote:

Did you hit enter have you applied the format change?

And you can't do this kind of formatting to formulas or real numbers.

It has to be text.

If you do this a lot...

John Walkenbach has a helpful addin that you may like:
http://j-walk.com/ss/excel/files/supersub.htm

allan wrote:

When I use the superscript option after selecting just a portion of the cell,
the superscript appears during edit mode only. How do I get it so it appears
as superscript on the spreadsheet or when printing? Again, I'm only trying
to superscript part of a cell's contents, not the entire cell.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson