Excel: Insert Roman Numbers
For example, inserting Roman numbers in Excel makes sense to structure data. In this practical tip we will show you how to do this.
Change the font
- Set the font to “Times New Roman”.
- For example, if you write "V", you will get the Roman five.
Insert symbols in Excel
Many symbols are also integrated in Excel. Including the Roman numerals.
- Go to "Insert" in the tab and "Symbols" in the menu on the far right.
- Set the font to "Arial Unicode MS" and the subset to "Numbers". Now you get the buttons in the symbol table to insert Roman numerals.
Formula turns Arabic Roman numerals
If you don't know the correct spelling for a Roman number, Excel can help you with that. With a formula you convert any Arabic number into a Roman.
- Select any cell and enter the following command: = roman (xxx)
- An example: If you enter the command = Roman (456), you will automatically receive the Roman notation "CDLVI".
This practical tip relates to Excel 2010.