DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Convert Numbers to Ordinal Numeral in Excel Office 365!!

In this article, you will understand the steps to Convert Numbers to Ordinal Numeral in Excel Office 365 using Kutools. For example, the numbers 1,2,3,… are converted to 1st, 2nd, 3rd,…and so on. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

Steps to Convert Numbers to Ordinal Numeral:

To do follow the below steps.

  • First, you need to select the number cells that you need to convert to ordinal numbers.

Example
Example

  • Go to the Kutools Tab, select the Content option, select the Convert Number to Ordinal option from the menu.

Choose Number to Ordinal option
Choose Number to Ordinal option

  • Now, all the selected numbers are displayed as ordinal numerals in the selected range as shown in the below screenshot.

Result
Result

Summary:

In this article, you can understand the steps to Convert Numbers to Ordinal Numeral in Excel Office 365 using Kutools. Kindly, share your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

Top comments (0)