Excel: Formatting dates with st, nd, rd etc?

Is there a way to format dates so instead of Monday 03 January it says Monday 3rd January and so on?

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of August 10, 2014.

For more resources for Microsoft Excel