Andi,

Chip Pearson can get you started...
http://www.cpearson.com/excel/ordinal.htm

Jim Cone
San Francisco, USA


"Andibevan" wrote in
message ...
Hi All,
Is there a way in excel to format a date so that it automatically includes
the "th" and "st".
I.e. so 1/8/05 -- 1st August 2005?
Ta
Andi