Maybe you could use a helper cell with a formula.

Chip Pearson has one at:
http://www.cpearson.com/excel/ordinal.htm

If A1 contains the date:
=TEXT(A1,"DDDD ") & DAY(A1)
&IF(AND(MOD(DAY(A1),100)=10,MOD(DAY(A1),100)<=14) ,"th",
CHOOSE(MOD(DAY(A1),10)+1,"th","st","nd","rd","th", "th","th","th","th","th"))
& TEXT(A1," MMMM YYYY")

All one cell.

StuartTheBrit wrote:

I would like Excel and Access to display dates in the following format:
Wednesday 3rd August 2005

Currently, I can only get a display of :
Wednesday 3 August 2005 using dddd d mmmm yyyy

Grateful for help getting 3rd instead of 3 displayed.

Many thanks

Stuart

--

Dave Peterson