Quickly convert numbers to ordinal numeral in Excel

Have you ever tried to convert or format the cardinal numerals to ordinal numeral in Excel, such as: 1 to 1st, 2 to 2nd, 3 to 3rd and so on? In Excel, you can apply several conditional formatting rules to format the numbers as ordinal numbers or use the Defined Function, but, both of them are complicated and troublesome. If you have Kutools for Excel, with its Convert Number to Ordinal feature, you can convert multiple numbers to ordinal numbers at once.

Click Kutools >> Content >> Convert Number to Ordinal, see screenshot:

Usage:

1. Select the number cells that you want to convert to ordinal numerals.

2. Then apply this utility by clicking Kutools > Content > Convert Number to Ordinal, and all the selected numbers have been displayed as ordinal numbers in the original range, see screenshots:

Notes:

1. This feature supports Undo (Ctrl + Z).

2. If the selection contains formulas cells, this feature will ask for your confirmation to remove formulas or ignore as following screenshot shown:

3. If you don’t want the converted results are displayed in the original cells, you just need to copy and paste the original data to another location you need，then apply the Convert Number to Ordinal feature.

Demo: convert numbers to ordinal numeral in Excel