How to Set Up an Ordinal Variable in Excel. An ordinal variable is a number that shows the position of an object within a series of objects with the use of a suffix, for example, "1st" or "453rd." ...

Adding an ordinal indicator – st, nd, rd, and th – uses a suffix to denote the value’s position within a series. For example, 1 becomes 1st, 2 becomes 2nd, 3 becomes 3rd, and so on. In Excel ...