Thread: how to format a cell to display October 21st, 2006
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default 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

Reply With QuoteReply With Quote