Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Superscript in custom format
I have started to use custom formats to display units. For instance when I
want a number to display as 24" or 58.2 lbf. I don't know if this is the proper way to do this, but it works great for me. The problem is I want one to display as 28in2 where the 2 is a superscript. Currently I have the output in one cell and the next cell is text "in2" with the "2" superscripted to signify inches squared. I would like a solution where I could combine the two cells into one cell that is still treated as a number when referencing from other cells. |
#2
|
|||
|
|||
Sloth
Use custom formatting on the numbers. i.e. FormatCellsCustom. Enter 0" in" then hold ALT Key and hit 0178 on number pad at right side of keyboard. No need for the extra cells. Can all be done in one cell and the 28 remains as a number. If you can use a macro it is possible to select a great whack of cells and just hit a button. Sub sq_inches() Selection.NumberFormat = "0"" in" & Chr(178) & """" '0179 for cubic inches End Sub Gord Dibben Excel MVP On Wed, 14 Sep 2005 14:05:04 -0700, "Sloth" wrote: I have started to use custom formats to display units. For instance when I want a number to display as 24" or 58.2 lbf. I don't know if this is the proper way to do this, but it works great for me. The problem is I want one to display as 28in2 where the 2 is a superscript. Currently I have the output in one cell and the next cell is text "in2" with the "2" superscripted to signify inches squared. I would like a solution where I could combine the two cells into one cell that is still treated as a number when referencing from other cells. |
#3
|
|||
|
|||
That's pretty clever. I didn't even think to use symbols. Now I can make
in² and in³ but what about in4? Any ideas? That is pretty much all I need except for maybe in-1. Thanks for the input "Gord Dibben" wrote: Sloth Use custom formatting on the numbers. i.e. FormatCellsCustom. Enter 0" in" then hold ALT Key and hit 0178 on number pad at right side of keyboard. No need for the extra cells. Can all be done in one cell and the 28 remains as a number. If you can use a macro it is possible to select a great whack of cells and just hit a button. Sub sq_inches() Selection.NumberFormat = "0"" in" & Chr(178) & """" '0179 for cubic inches End Sub Gord Dibben Excel MVP On Wed, 14 Sep 2005 14:05:04 -0700, "Sloth" wrote: I have started to use custom formats to display units. For instance when I want a number to display as 24" or 58.2 lbf. I don't know if this is the proper way to do this, but it works great for me. The problem is I want one to display as 28in2 where the 2 is a superscript. Currently I have the output in one cell and the next cell is text "in2" with the "2" superscripted to signify inches squared. I would like a solution where I could combine the two cells into one cell that is still treated as a number when referencing from other cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell contents with custom time format rounded after double-click | Excel Discussion (Misc queries) | |||
Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
Format Number (custom) | Excel Discussion (Misc queries) | |||
Number Format (custom) | Excel Discussion (Misc queries) | |||
Custom Number Format... | Excel Worksheet Functions |