1st, 2nd, 3rd, on Date Format
 

Looking to create a custom number format in a cell so that when I put the
date it updates it with the relevent st, nd, rd or th on the end of the date
entered

So that when I enter the
01/10/2005
it would display
1st October 2005

when I enter the
22/10/2005
22nd October 2005

i.e.
st, on the 1, 21, 31;
nd on 2, 22;
rd on the 23
and th on all the remainder of the dates within Excel date display entered
from the cell format

TIA
Michael

1st, 2nd, 3rd, on Date Format
 

The Ordinals man (among other things!):
http://www.cpearson.com/excel/ordinal.htm
************
Anne Troy
www.OfficeArticles.com

"Michael" wrote in message
...
Looking to create a custom number format in a cell so that when I put the
date it updates it with the relevent st, nd, rd or th on the end of the
date entered

So that when I enter the
01/10/2005
it would display
1st October 2005

when I enter the
22/10/2005
22nd October 2005

i.e.
st, on the 1, 21, 31;
nd on 2, 22;
rd on the 23
and th on all the remainder of the dates within Excel date display entered
from the cell format

TIA
Michael

1st, 2nd, 3rd, on Date Format
 

Also have a look at this google search thread for ordinal dates and methods of
returning.

Cannot be done through formatting alone. Either formula in a helper cell or
use Ron Rosenfeld's event code.

http://snipurl.com/iwlr


Gord Dibben Excel MVP

On Sun, 23 Oct 2005 16:54:49 -0400, "Anne Troy" wrote:

The Ordinals man (among other things!):
http://www.cpearson.com/excel/ordinal.htm
************
Anne Troy
www.OfficeArticles.com

"Michael" wrote in message
...
Looking to create a custom number format in a cell so that when I put the
date it updates it with the relevent st, nd, rd or th on the end of the
date entered

So that when I enter the
01/10/2005
it would display
1st October 2005

when I enter the
22/10/2005
22nd October 2005

i.e.
st, on the 1, 21, 31;
nd on 2, 22;
rd on the 23
and th on all the remainder of the dates within Excel date display entered
from the cell format

TIA
Michael