Superscripts

M

Mark Hatfield

Can you superscript only some of the numbers in a cell? I am using Excel
2003.

Mark
 
T

Trevor Shuttleworth

Mark

You seem to be able to select some of the characters in the middle of an
alpha string and superscript them ... but numbers seem to revert to normal
font. No idea why.

You can format the cell as text, or put a single quote (') in front of a
number to make it text and then superscript some of the numbers. However,
to do arithmetic, you might need to force it back to numeric.

For example if the number was in cell A1, formatted as text and
superscripted,

=--A1 would coerce it back into being numeric if you need to do arithmetic
on it.

Regards

Trevor
 
J

Jerry W. Lewis

But be aware that coercion may not produce the desired result. For instance
3 superscript 2 is probably intended to mean "three squaared" or 9, but it
would coerce to the numeric value of 32.

Jerry
 
S

Sandy Mann

I assume that the thanks was intended for Trevor & Jerry as well who also
had valid points.

Because you only asked about superscript I assumed that you wanted to write
something like 12 2 with the 2 superscript to indicate squared. If so then
you can still use the cell in a calculation thus:

=--LEFT(F25,LEN(F25)-1)^--(RIGHT(F25,1))

though you could equally well use 12^2 in an adjacent cell and custom format
the cell as ;;;

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
T

Trevor Shuttleworth

Agreed ... but you wouldn't actually have 3 squared in the cell, you'd have
32 with the 2 superscripted. Maybe we're over-interpreting what the OP
wanted ?

Sandy makes some good points that might address the underlying problem that
the OP wanted to fix ... who knows ?

Regards

Trevor
 
Top