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?
2 on the mm. How can I write that in excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Hi
Type Kg-mm then choose Insert>Symbol>select Superscript 2>OK>Enter
Type Kg-mm then choose Insert>Symbol>select Superscript 2>OK>Enter
R
Roger Govier
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.
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.
S
shriil
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?
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.Font ---> Tick the checkbox for "Superscripts" under the "Effects"
Hope this would suffice
Shriil
C
Chip Pearson
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)
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)