Hi,

I am trying to get the date, entered as 06/04/2002 to display as Saturday
6th Apr 2002

I have got as far as Saturday 6 Apr 2002 with the custom format: dddd d mmm
yyy

What do I enter in the Custom category of the dialogue box that opens when I
go to FormatCells?

I would like to have the "th","st","rd","nd" displayed, by entering
something similar to "dddd d mmm yyy" in the custom category of the format
cells dialogue box.

Thanks,

Phil