Adding st, nd, rd, and th to numbers

[JO505]

I forgot the formula to add a suffix to a number to produce 1st, 2nd, 3rd etc.

Jim O

[martindwilson]

see here
http://www.cpearson.com/Excel/ordinal.aspx

[alansidman]

Here you go: http://www.cpearson.com/Excel/ordinal.aspx


Edit: Nicely done Martin.

[Pete_UK]

That type of numbering is called ordinal - just put ordinal in the search box at the top of the screen then click the search icon next to the box (magnifying glass) to get lots of threads on the subject.

Hope this helps.

Pete

[JO505]

Thank you all very much for the quick response.

Jim O