Perhaps you only need up to 31 but this formula will convert an integer
in A1 to an ordinal number
=A1&IF(OR(MOD(A1,100)={11,12,13}),"th",CHOOSE(MIN( MOD(A1,10)+1,5),"th","st","nd","rd","th"))
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=523354