Most spreadsheets are full of numbers. Some of them include text. How do you do this in Excel? This means that you can look for it, or use Flash Fill to change all m2’s to m². In order to insert a square symbol in Excel, you have to do the following. button and then type in the corresponding code for this character. c2 = a2 + b2 , Select first 2 and expand the font window ( …
Pete C Microsoft MVP Internet Explorer 2004 - 2011 Keep all responses to BBS
The other option is to insert the ² symbol. Type =N^2 into the empty cell, in which N is a cell reference that contains the numeric value you want to square. The benefit of using this method is that Excel sees this ² as a different character from a 2 that is formatted. You know the little '2' you put next to a number ro show its squared. I can't find anything in the help for Excel nor in word. But if you want to. How to Insert Symbols and Special Characters in Excel (Quick and Easy) Written by co-founder Kasper Langmann, Microsoft Office Specialist. You can square a number in Excel with the power function, which is represented by the carat ^ symbol.Use the formula =N^2, in which N is either a number or the value of the cell you want to square. All you need to do is to hold down the Alt button and then type in the corresponding code for this character. Enter the formula, you want to use. Below is the keyboard shortcut to insert a square root symbol in a cell in Excel: ALT + 251 This means that you need to hold down your ALT key and press the numbers 2, 5, and 1 on the numeric keypad. E.g. Alt Code You can insert a square root symbol in Excel using only your keyboard, without any additional steps.