how to format a cell to display October 21st, 2006
 

I understand how you can change a format for 10/21/2006 into October 21,
2006, but I want to put in the "st" part in.
And once I have that format in, even if I type in 10/23/2006, then it would
show October 23rd, 2006 and would show the "rd" automatically.

how to format a cell to display October 21st, 2006
 

Hi Naomi,

Take a look at Chip's brilliant solution with ordinal numbers :

http://www.cpearson.com/excel/ordinal.htm

HTH
Cheers
Carim

how to format a cell to display October 21st, 2006
 

See http://xldynamic.com/source/xld.RANK.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Naomi" wrote in message
...
I understand how you can change a format for 10/21/2006 into October 21,
2006, but I want to put in the "st" part in.
And once I have that format in, even if I type in 10/23/2006, then it
would
show October 23rd, 2006 and would show the "rd" automatically.