Starting with Excel 2007, it is possible to specify the number format as part of conditional formatting. This note shows how to leverage that capability to add the appropriate suffix to an ordinal number (e.g., 1st, 2nd, 3rd, 4th, etc.)
For a version in a page by itself (i.e., not in a scrollable iframe as below) [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/04/18/ordinal-numbers-suffixes/
Posted
Apr 18 2011, 02:08 AM
by
Daily Dose of Excel