superscript ordinals excel

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

In excel how do I get the 15th to show the th in superscript and leave the 15
as normal.
 
Type
15th
in a cell

This technique doesn't work with formulas or real numbers (but works ok with
Text numbers.)

Select the "th" in the formula bar
Format|Cells
Check superscript.

If you have lots to do, you may want to try John Walkenbach's utility:
http://j-walk.com/ss/excel/files/supersub.htm
 
Select just the "th" in the cell. Right click. Choose Format Cells... Under
Effects, check superscript.

Regards,
Fred.
 
I guess 15th is text, not value (cannot make check as I do not have english
excel).
If it is text edit the cell (F2), higlight "th" by mouse, righ-click, choose
format cells -text, check superscript, press ok, hit enter.
 
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

Superscript and Subsript 2
Superscript in Custom Format 2
Is it possible to use Subscript and superscript in excel? 2
Formating issues 1
How do I add Subscript and Superscript buttons to Excel 2002 toolb 1
Superscripts in a cell 8
Superscript Font in Excel Chart 1
Concatenate cells containing exponents 5

Back
Top