Superscript

Location on ribbon: Tab DVD Addin → Group Text and Number → Menu Text ops

Command ID: btnSuperscript

What it does

The command walks every cell in the selection and applies superscript to any digit that comes immediately after the letter m or M. So m2 displays as m², m3 as m³, cm2 as cm², km3 as km³.

Tidying units this way is effectively mandatory before printing a bill of quantities, an estimate or a contract annex: the unit of measure has to read m² and m³, not m2 and m3.

How to use

1. Select the unit column, or any range that contains units of measure.
2. Go to tab DVD Addin → group Text and Number → menu Text ops → Superscript.
3. It runs immediately, with no dialog. The status bar reports how many cells were formatted.

Example

The "Unit" column of a concrete and finishing works quantity sheet.

Before	After
m2	m²
m3	m³
cm2	cm²
kg	kg (unchanged)

The printed sheet meets the documentation standard without typing special characters or restyling cells one by one.

Notes

• Only the character formatting changes; the cell value is still m2. Comparison formulas, VLOOKUP and PivotTables therefore still read m2 — usually exactly what you want.
• Only a digit immediately following m/M is raised; strings like T3 or A2 are untouched.
• Formula cells cannot take per-character formatting and are skipped silently.
• If you later edit the cell text, the superscript formatting may be lost and the command has to be run again.
• Ctrl+Z cannot undo this.

Related

• Subscript — lowers the digits in chemistry formulas instead.
• Font Change — style part of a cell's content independently.
• Remove extra spaces — collapse m 2 into m2 first so the rule can match.
• Smart Data Cleaning… — normalise the unit column before applying the formatting.