Ordinal Number Format in Excel

shyam131 · Apr 21, 2004

Does anyone know how create/use an ordinal number format in Excel. Fo
example 1st, 2nd, 3rd. That is to say convert 1 to 1st or 2 to 2nd

Debra Dalgleish · Apr 21, 2004

Chip Pearson has functions for creating ordinal numbers:

http://www.cpearson.com/excel/ordinal.htm