Hi

There is no such format in Excel. And you will have to write a custom
function that gives you the date in the format you want.
Here is a solution but this solution will work only for your current
requirement.

Right click the cell where u have ur date select format and enter this
as a custom format.

d"rd" mmmm yyyy

But this will not work for say for 2nd or 4th and you will have to
change the custom format.

Thanks
Karthik Bhat
Bangalore