View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Rookie 1st class Rookie 1st class is offline
external usenet poster
 
Posts: 152
Default display extension for date in excel

I added "(space)yyyy" to your existing formula and it worked for me
Lou

"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