Hello-

Excel provides no such date formatting, and trying to create a custom format
like that would be impossible due to the variable 'st', 'rd', 'th', etc. &
when each should be used.

Perhaps it can be accomplished with VBA, but unless someone has it available
& is willing to share, it would probably be more trouble to write than its
worth... Unless you need to use the dates for calculations.

Regards |:)

"Andibevan" wrote:

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