Ordinal Numbers
As in 1st, 2nd, 3rd, 4th, 5th etc
=A1&IF(OR(RIGHT(A1,2)="11",RIGHT(A1,2)="12",RIGHT(A1,2)="13",MOD(A1,10)=0,MOD(A1,10)>=4),"th",CHOOSE(RIGHT(A1,1),"st","nd","rd"))
© Copyright
andrewsexceltips.net
All Rights Reserved.