Hi

Format the cell with a custom format
FormatCellsNumberCustom #0.0 "mmAlt0178"

Holding down the Alt button, whilst typing 0178 on the Numeric keypad,
will create the superscript 2 as soon as you release the Alt key and it
should appear as mm²

Change the number format #0.0 to suit the precision you wish to display.
This method has the advantage that any numbers entered to the cells can
still be used in further calculations.


--
Regards

Roger Govier


"Hi_no_Tori" wrote in message
...
Hi...
Can I format a cell, so that when I enter for example: "120 mm2", the
"2" is
converted automatically to superscript.