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

M

Michael

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to custom format a date 5
Date import using numerical abbreviations - 1st, 2nd, 3rd etc. 2
conditional formatting 3
Date abbreviations / extensions 6
showing dates, e.g. 1st, 2nd, 3rd with st, nd, rd in superscript 3
1st and 2nd.... positions 21
customize date 11
number of months and days between two dates without approximation 3

Top