Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I write mm square, with 2 show up on top of mm.?
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I write mm square, with 2 show up on top of mm.?
Hi
Type Kg-mm then choose InsertSymbolselect Superscript 2OKEnter -- Regards Roger Govier "Ck" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I write mm square, with 2 show up on top of mm.?
Hit the send button too soon.
You could create that with the method described then Copy the value. FormatCellsNumberCustom 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. -- Regards Roger Govier "Ck" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I write mm square, with 2 show up on top of mm.?
On Feb 6, 9:47*pm, Ck wrote:
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" -- Font --- Tick the checkbox for "Superscripts" under the "Effects" heading in the "Font" Tab. --- Press "OK". Deselect the cell. Hope this would suffice Shriil |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I write mm square, with 2 show up on top of mm.?
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) On Fri, 6 Feb 2009 08:47:02 -0800, Ck wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write a superindex in excel? (e.g. for square meter m2) | Excel Discussion (Misc queries) | |||
How do I a rotate my square radar chart (square-diamond)? | Charts and Charting in Excel | |||
how to center a square plot area in a square chart | Charts and Charting in Excel | |||
Regression Output -- R Square versus Adjusted R Square | Excel Discussion (Misc queries) | |||
Formating to show square meters ie m2 | Excel Discussion (Misc queries) |