How can I write mm square, with 2 show up on top of mm.?

  • Thread starter Thread starter Ck
  • Start date Start date
C

Ck

I want to write the unit for the motor inertia. i.e. Kg-mm2. but i want that
2 on the mm. How can I write that in excel?
 
Hit the send button too soon.

You could create that with the method described then Copy the value.
Format>Cells>Number>Custom> General "> Control+V to paste> " >Enter

The cells you have formatted this way will appear blank.
Once you type in a number, e.g. 50, then it will appear as 50 KG-mm²
This has the advantage that the number can still be used in further
calculations if required.

Rather than General, you could set the format before the text to be 0.00 or
whatever number format you want to work to.
 
I want to write the unit for the motor inertia. i.e. Kg-mm2. but i want that
2 on the mm. How can I write that in excel?
Click to expand...

Here is one option. First write the stuff in the cell: "mm2". With
the cell selected, go to the formula bar where "mm2" will be
displayed. With the help of the cursor just highlight/select the "2"
from the "mm2" in the formula bar. Right click, go to "Format Cells" --
Font ---> Tick the checkbox for "Superscripts" under the "Effects"
Click to expand...
heading in the "Font" Tab. ---> Press "OK". Deselect the cell.


Hope this would suffice

Shriil
 
If you want to format a number to display the units, select the
cell(s), go to the "Format" menu, and choose "Cells". In that dialog,
choose the "Number" tab and then "Custom" in the "Category" list. In
the "Type" text box, enter

#,##0.00" Kg-mm"²

You can get the ² character by holding down the ALT key and typing
0178 on the numeric keypad (to the right of the letter keys -- don't
use the numbers above the letters. the leading 0 is required).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
shriil said:
Here is one option. First write the stuff in the cell: "mm2". With
the cell selected, go to the formula bar where "mm2" will be
displayed. With the help of the cursor just highlight/select the "2"
from the "mm2" in the formula bar. Right click, go to "Format Cells" --
heading in the "Font" Tab. ---> Press "OK". Deselect the cell.


Hope this would suffice

Shriil
Click to expand...

it helps, thanks.
 
Back
Top