How do you type 'squared' in Excel??

You know the little '2' you put next to a number ro show its squared. How do you do this in Excel? I can't find anything in the help for Excel nor in word.

I'm using Office XP

Thanks

 

Hi, Do you mean how to square a number or how to show the square symbol
in a cell's description ? eg

²
regards

 

Yes! Exactly like that. How do you do it?

 

Hold down the ALT key and from the numberpad, type 0178 then release the ALT key.

Alt-0178 = ²
Alt-0179 = ³
Alt=0190 = ¾
start~run~charmap gives you the whole list. They work pretty much anywhere in Windows.

 

Why they can't have a button for subscript and superscript as in Word (via customization) is beyond me.

As no one else mentioned it. If you want squared in an equation you can use ^ as in:

=2^2

Which will give 4 in the cell.

=2^3

will give 8

 

...Tried that in Word works perfectly, however in Excel it reverts back to the same size font as the a. If I cut and paste from Word into Excel, it reverts it back too??

The odd thing is it changes, then when you go back to format, cells, font and remove the tick it all changes back to the normal size. Same goes for when you select another cell??

 

Never seen a thread here before with 75 % + UK posts/replies !
Pleased pondlife got some good tips. Newt mentions the Windows Charmap
usage. Sometimes you have to juggle around in the different Fonts you have,
as the character map per Font is different.
Does anyone have a comprehensive list of the ALT[Number] symbols ?
regards

 

Its ok I've sorted it now, you have to make sure there is a space between the a and the 2 then it will alow you to 'mix fonts' in the same cell.

Thanks all for your help

 

Merlin - sorry but the only way I know of to get such a list would be to do one.

Pondlife - isn't this what you were wanting?

 

Hi Newt, I am getting on in years. I do not think I will finish
(9!/4!) combinations (15'120) within what's left to me

Anyway, Edith Starr does as good a job with this topic as anyone :

---> here

regards