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

[Guest]

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.

 

[Carim]

Hi Naomi,

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

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

HTH
Cheers
Carim

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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