View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Naomi Naomi is offline
external usenet poster
 
Posts: 26
Default 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.