• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Custom number format for cubic feet?

D

DashboardNovice

Member
I'm trying to apply custom number format for cubic feet. Cell E7, has an example of what the result should look like. However, when I try to do that in custom number format in cell G7, I can't do a superscript. I also tried using a ^ and that didn't work.

Is there a way to do apply a custom number format for cubic feet?
 

Attachments

  • Custom Number Format - Cubic Feet.xlsx
    8.8 KB · Views: 4
vletm said:
... how?
I find it from my fonts and pasted it there.
Click to expand...

I don't understand. I typed in 3 in a blank cell and applied a superscript. Then when I copied that and pasted into custom number format, it went in as an ordinary 3, instead of a superscript 3.

What steps did you take?
 

DashboardNovice​

My way:
#1 activate any cell
#2 Insert > Symbol...
#3 Search 3
#4 Click a superscript 3
#5 Copy result of above for use
Or
You could try to use Unicode Character “³” (U+00B3)
Or
Google superscript 3 in excel
For example, to create a custom number format for superscript 3,
type 0, press the Alt key, type 0179 on the numeric keypad, then release Alt. Click OK
 
To create a custom number format for superscript 3:

1] type: 0 ft

2] then press the Alt key, type 0179 on the numeric keypad, then release Alt.

Remark:
Superscript 2 Alt 0178
Superscript 3 Alt 0179

1690722041723.png
 
Last edited:
vletm said:

DashboardNovice​

My way:
#1 activate any cell
#2 Insert > Symbol...
#3 Search 3
#4 Click a superscript 3
#5 Copy result of above for use
Or
You could try to use Unicode Character “³” (U+00B3)
Or
Google superscript 3 in excel
For example, to create a custom number format for superscript 3,
type 0, press the Alt key, type 0179 on the numeric keypad, then release Alt. Click OK
Click to expand...

It worked. Awesome. Thank you.
 
DashboardNovice said:
Interesting. So it looks like 0179 is uniquely associated with superscript 3. What is 0179 called? I don't think it's called Unicode.
Click to expand...
It is called Excel shortcuts

However
  • These shortcuts work for Calibri and Arial If you are using some other font, the character codes may be different.
  • The numbers with superscripts are turned into numeric strings, meaning you won't be able to perform any calculations with them.
 
bosco_yip said:
It is called Excel shortcuts

However
  • These shortcuts work for Calibri and Arial If you are using some other font, the character codes may be different.
  • The numbers with superscripts are turned into numeric strings, meaning you won't be able to perform any calculations with them.
Click to expand...

I know about keyboard shortcuts, but I didn't know about shortcuts. If you know of any good sources (websites) I would be interested in it.
 
DashboardNovice said:
Interesting. So it looks like 0179 is uniquely associated with superscript 3. What is 0179 called? I don't think it's called Unicode.
Click to expand...
Please see this Unicode symbols link:

www.vertex42.com

Huge List of Unicode Character Symbols

This page provides a set of tables for Unicode character symbols, including emojis, emoticons, arrows, music, sports, etc.
www.vertex42.com www.vertex42.com

And,

1] Here is how to use Char or Unichar functions for superscripts and symbols

2] Please see attached file

1690777689063.png
 

Attachments

  • unicode-symbols code list.xlsx
    10.4 KB · Views: 2
You must log in or register to reply here.
Back
Top