Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Superscript in a Custom Format
I use custom formatting to display units (such as "28 in²"). I need in^4
though and can't figure out a way to get it to show like m² or kg³. Does anyone have any tips? I can't simply type in the units and use superscript because the cells are mostly formulas. I currently use two rows: one for the value and one for the unit. This doesn't line up the way I would like it to though. PS: In case you wanted to know, this how to get 0-3 superscripted. They are just symbols and can be found in Microsoft Word when you Insert-Symbol and select "normal text" as the font. Thanks goes to Gord Dibben for showing me this in a previous post. alt+0186 = º alt+0185 = ¹ alt+0178 = ² alt+0179 = ³ |
#2
|
|||
|
|||
You can't superscript characters with formatting.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sloth" wrote in message ... I use custom formatting to display units (such as "28 in²"). I need in^4 though and can't figure out a way to get it to show like m² or kg³. Does anyone have any tips? I can't simply type in the units and use superscript because the cells are mostly formulas. I currently use two rows: one for the value and one for the unit. This doesn't line up the way I would like it to though. PS: In case you wanted to know, this how to get 0-3 superscripted. They are just symbols and can be found in Microsoft Word when you Insert-Symbol and select "normal text" as the font. Thanks goes to Gord Dibben for showing me this in a previous post. alt+0186 = º alt+0185 = ¹ alt+0178 = ² alt+0179 = ³ |
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 |