custom date format: 22nd Nov 2005

oliver_penney

Board Regular
Joined
Dec 18, 2002
Messages
182
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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Nope, Microsoft, in their infinite wisdom, omitted that option from the date formats.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,383
Messages
5,571,818
Members
412,420
Latest member
Quintankerus
Top