It is believed to be the shortest formula that will add the ordinal suffixes
to a number. As I posted to Glenn, you might be interested in the genesis
for that formula. Click the link below and read messages 2 thru 11...
http://groups.google.com/group/micro...thor:rothstein
--
Rick (MVP - Excel)
" wrote in message
...
wow I have to check that formula out
"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. ?