On Thursday, February 12, 2009 at 4:26:04 PM UTC-5, Rick Rothstein wrote:
Try this formula...

=A1&MID("thstndrdth",MIN(9,2*RIGHT(A1)*(MOD(A1-11,100)2)+1),2)

--
Rick (MVP - Excel)


"Bob Arnett" wrote in message
...
Is there any way to display numbers in the mode of:
1st
2nd
3rd
4th
etc. ?

Thanks, this was just what I needed!