Thread
:
formatting numbers as 1st 2nd
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein
external usenet poster
Posts: 5,934
formatting numbers as 1st 2nd
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. ?
Reply With Quote
Rick Rothstein
View Public Profile
Find all posts by Rick Rothstein