On Sat, 20 Dec 2008 14:58:38 +0000, Terry Pinnell
wrote:

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'?


Try a Custom cell format

DDD DD\th MMM, YYYY

It will however always display "ht" after the data, like 1th and 2th
instead of 1st and 2nd as you probably want.

Hope this helps / Lars-Åke