custom date format: 22nd Nov 2005

[oliver_penney]

hi

quick question, is there a custom date format that puts "st", "nd", "rd" or "th" after the number in a date format (or even a number format i suppose)

e.g. 22nd nov 05

if there's not, no worries, could always do it the hard way with a few IFs

 

[GlennUK]

Have a look here:

http://www.cpearson.com/excel/ordinal.htm

 

[oliver_penney]

ah

thanx

looks like there's no custom format then

 

[GlennUK]

Nope, Microsoft, in their infinite wisdom, omitted that option from the date formats.