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
|