How to specify this date format?

[Terry Pinnell]

Is there any way to specify that a date entered as say 20/12/08 should
be displayed in Excel 2000 as 'Sat 20 December 2008' please? Even
better, 'Saturday 20th December, 2008'?

 

[Terry Pinnell]

One way:

Format/Cells/Number/Custom "ddd dd mmmm yyyy"

Thanks all, much appreciated. I've gone for "ddd dd mmmm yyyy" for the
time being but will try the more complex alternatives later.