Ordinal Number Format
How about an option to format as ordinal numbers, similar to what can be done in fields in word with *Ordinal
Thanks for info, but really we shouldn't need add-ins to do this.
How about adfding it to the available format in the TEXT() formula
if A1 = 1 returns "1st"
if A1 = 11 returns "11th"
Kenneth Barber commented
The add-in FormulaDesk gives you ordinal numbers.