Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing Font in cells
I would like to know how to make a superscript number... i think i forgot how.
|
#2
|
|||
|
|||
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. ---- Regards, John Mansfield http://www.pdbook.com "Donald" wrote: I would like to know how to make a superscript number... i think i forgot how. |
#3
|
|||
|
|||
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 John Mansfield wrote: 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. ---- Regards, John Mansfield http://www.pdbook.com "Donald" wrote: I would like to know how to make a superscript number... i think i forgot how. -- Dave Peterson |
#4
|
|||
|
|||
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 On Fri, 22 Apr 2005 08:07:04 -0500, Dave Peterson wrote: 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 John Mansfield wrote: 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. ---- Regards, John Mansfield http://www.pdbook.com "Donald" wrote: I would like to know how to make a superscript number... i think i forgot how. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
Changing font size in a list box | Excel Discussion (Misc queries) | |||
Changing default font in comments? | Excel Discussion (Misc queries) | |||
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) | |||
Changing Colors of Cells | Excel Worksheet Functions |