Changing Font in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know how to make a superscript number... i think i forgot how.
 
Donald,

Assume you have the number 12345 in cell A1. Put your curser in cell A1.
You should see 12345 in the formula bar. Go to the formula bar and highlight
or select 1. Go to the standard toolbar and select Format -> Cells ->
Effects -> Superscript.
 
Just to add to John's reply....

This formatting will only work with text entries. If you have 12345 in a cell,
make sure that the cell is formatted as text before you type in the 12345--or
you prefix it with an apostrophe: '12345
 
Just to add to both replies.....

If you are in need of something like 12345m² (meters squared)

You can custom format to 0"m then hold ALT key and enter 0178 and "

0179 for meters cubed.

Your original 12345 can remain as a number.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to change part of cell 2
Superscript in Custom Format 2
Superscripts in a cell 8
Math formulas possible with overstrike characters? 2
Excel Paste Formating 3
automatic font change 5
How do I add subscript/superscript font to the Excel toolbar?? 1
Superscript and Subsript 2

Back
Top