Dates with a th as Superscript

Hello All,

Does anyone know of a way to format a dates with the st nd rd th added after the day as a superscript for example 19th July 2010

I've tried googling and searching here but no joy.

Idealy I'd like to create a function that does this as I use dates all the time.

Thanks in advance

David

See http://www.excelforum.com/tips-and-t...-nd-rd-th.html.

However, I suggest you resist the urge; the result will be text, useless for downstream calculation.

How about a worksheet_change macro using Case to determine how to custom format the cell (mmm d"st" yy or mmm d"nd" yy etc)? This will allow you to continue to work with the dates as numbers.

Here's some code that should work. Insert it into your worksheet code

Please Login or Register  to view this content.

Does this work for you?

As far as I know that is not possible unless you convert the value from date to text.

Text is fine as I'm using the dates for a mail merge to word and the superscript would match the Word format for dates.

You could use something like this:

Please Login or Register  to view this content.