There are many ways to type square meters in Excel**, such as using input methods, using formulas and shortcut keys, etc. Below, we will share several ways to enter the symbol of square meters (m) in Excel.
Method 1: Use caret
1.Open the insert menu in Excel and select "Symbols".
2.In the dialog box that appears, select the Custom Symbols tab.
3.Find the "square meter" symbol and click insert.
Method 2: Use shortcut keys.
1.Enter the letter M in Excel.
2.The input method ensures that it is adjusted to English. Press and hold the Alt key without releasing it, then press 178 on the keypad (the right number area on the keyboard) and then release the Alt key. The square meter symbol appears in the cell.
3.Typing m in front of the square meter symbol becomes .
Method 3: Use Set Cell Formatting.
1.Select the cell that you need to enter square meter symbol in Excel.
2.Right-click on the cell and select "Format Cell".
3.In the dialog box that appears, select the Customize tab.
4.Enter "m" in the "Type" text box and click "OK".
Method 4: Use mathematical formulas.
1.Enter M2 in Excel.
2.Select 2, right-click the selected 2, and select "Format Cells".
3.In the pop-up dialog box, select the "Superscript" option and click "OK". This will appear as a symbol for square meters.
Method 5: Use input method.
1.Open the input method, such as Sogou input method, input method, etc.
2.Enter the pinyin of square meters, and then select the candidate words. It is also possible to use special symbols, found in mathematical symbols.
Method 6: Use the method of inserting formulas.
1.Open the insert menu in Excel and select "Formula".
2.In the formula editor that pops up, enter m and 2 and select the superscript option.
Method 7: Use the way to format cells.
Select the cells that need to enter square meter symbols in Excel, right click and select "Format Cells", select "Number" tab in the popping up dialog box, select "Custom" in the "Classification" drop-down menu, and enter "0" in the "Type" text box".00"(0)", click "OK". This method preserves two decimal places and automatically adds the square meter symbol.
The above information is for reference only, and may vary due to different versions of office software. Please choose which method to choose according to your personal Xi habits.
Demo environment. Hardware model: Huawei MateBook D 15
Software version: Windows 10, WPS 365
App version: None.