Superscript and Subscript in Excel
How to write H2O, m2, m3, Mark for a Footnote in Excel
In this tutorial and in this example I will show how we can write in Excel items: H2O, m2, m3, CH4, a Mark for a Footnote
In Excel cell you type the text that contains any subscript and superscript tags. Double-click the cell you select the number to convert as subscript or superscript. While the number selected, right-click the selection, and the pop-up menu or the shortcut menu, you select Format Cells.
In a new dialog box, you enable the option for Superscript and if you want to create a number as Subscript enable the option below.
All, I explained above looks like as shown below. (examples m2 = square meter, m3 = cubic meter, H2O = formula for water chemistry).
Display a Measurement Unit Beside the Value by Custom Format Cells (1750 m2, 120 m3, 7 kg)
If you you need to form a format cell that is not standard form then you do remodeling through custom formatting for certain representations of design. eg: design display the number value in 1750 as a unit of measurement m2 or displaying units cubic meter.
Custom format cell should look like this: 0" m2" or 0" m3" or 0" kg".