View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default display extension for date in excel

I posted yyyy

But I guess you are actually after the "st" "nd" "rd" "th" to be added
after 1,2,3,4 etc

TBH I don't know

You can construct the string with a formula, but not perhaps what you
wanted.

Steve


On Tue, 14 Nov 2006 18:38:02 -0000, Phil
wrote:

I would like to display a date typed in as 06/04/2002 as Saturday 6th
April
2002

I have got as far as dddd dd mmm in the custom number type,which displays
Saturday 6 April.

How do you get the extension to display?

Thanks,

Phil