excel 2007 make number appear square/cubed

[johnny52]

Hey

In excel 2007 is there a way to put two numbers into a cell and
make one smaller and raised to appear squared or cubed

say I have two numbers 75 and 87

I would like the 75 normal format but the 87 to appear next to it smaller and raised
higher up.......I tried concatenate,exact,absolute....but not really sure if this can be done.

thanks everybody

 

[RichardMGreen]

It should be possible using formatting on just the cell you want. So if you just highlight 87 in the formula bar and format that to superscript it should give you what you want.

 

[p45cal]

Not if the cell contains a formula.
Otherwise a macro to convert formula to text value, then you can superscript part of it. So a macro might include:

With Selection
.NumberFormat = "@"
.Value = .Text
.Characters(Start:=3, Length:=2).Font.Superscript = True
End With

 

[johnny52]

don't really want to use a macro....the worksheet I'm using has two columns of numbers
just always want that 2nd column to appear in the first column smaller and raised

not sure what superscript does either

Thanks again

 

[RichardMGreen]

Superscript makes the text/number about half the size of normal text/numbers and appear at the top of the cell.

 

[johnny52]

ok superscript worked...but if I concatenate the two cells the second number goes back
to it's regular size

I like one regular and the second superscipt all in one cell...only a macro

makes this work ?

Thanks !

 

[RichardMGreen]

If you're using a formula to concatenate the two cells, then only a macro will work.
You could put the macro from P45CAL into a Selection_Change or Worksheet_Calculate event so it happens automatically.

 

[johnny52]

ok

I'll put in the macro and see how it goes.

thanks

 

[johnny52]

so if I have 87 in cell a1 and 74 in b1

how would your macro look then......As you said it will only work this way
because I have that concatenate in cell c1

Thanks Again for the help

 

[johnny52]

well

I took out the concatenate formula.....put the numbers back to 2 cells
superscripted the second number
then right aligned one left aligned the other one
then hid the gridlines on the specific area of worksheet...... patterned and bordered it white/gray

on the printout it looks ok...........not a macro but it works for me

Thanks Everybody