ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   exel 2000 st in 21st to move up (https://www.excelbanter.com/excel-discussion-misc-queries/20179-exel-2000-st-21st-move-up.html)

vikesanimal

exel 2000 st in 21st to move up
 
how can i get the nd, st, and th in numbers like 21st to move up and get
smaller like in word.

JulieD

Hi

it's called superscript, but as far as i know you have to do it manually,
e.g.
type 21 choose format / cells / font - tick superscript, ok
type st


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"vikesanimal" wrote in message
...
how can i get the nd, st, and th in numbers like 21st to move up and get
smaller like in word.




Dave Peterson

John Walkenbach has a helpful addin that you may like:
http://j-walk.com/ss/excel/files/supersub.htm

vikesanimal wrote:

how can i get the nd, st, and th in numbers like 21st to move up and get
smaller like in word.


--

Dave Peterson


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com