Inserting characters into excel

[benjf1]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I need to insert a squared sign into excel however there is no such character in the symbols section.

any advice would be much appreciated

 

[katie_c]

As part of a formula, use ^2.

For display purposes, you will need to use formatting menu. Enter x2 into a cell, highlight the "2" in the cell, click on format menu, go to Cells. Then select Fonts and enable Superscript option. That will display the 2 as a superscript and leave the rest of the cell normal.

-Katie