Wendy,

You can't do it through formatting, which is why I posted a formula.

HTH,
Bernie
MS Excel MVP


"Wendy D" wrote in message
...
Dave, that's the type of thing I'm looking for (although I will try the other
suggestion if I don't find anything this easy), however when I use that in
the custom field, I don't get the ordinals, only the full month. EX: I get
Jaunary 4, not January 4th. Do you know what else to add?

Thanks!

"David Billigmeier" wrote:

Format-Cells-'Number' tab-Click on "Custom" and type this formula:

[$-409]mmmm d


--
Regards,
Dave


"Wendy D" wrote:

Wondering if excel can express mmm dd dates including their ordinal?
Examples a May 4th, October 1st, June 3rd.

Thanks!
Wendy