
Roman numerals are practically not used in everyday life, especially when it comes to accounting or other areas where spreadsheets are used, which are built in Microsoft Excel. However, it is possible that in some projects the user needs to write Roman numerals, which can cause problems. I will show two working methods that are suitable for the implementation of the task.
I would like to draw your attention to the fact that it is not possible to perform mathematical operations with Roman numerals in Excel, even if they have been converted using the built-in function from Arabic numerals. Keep this feature in mind when reading the following instructions.
I haven’t talked about the fact that you can use capital Latin letters on the keyboard to just type Roman numerals, such as XVII, and other random combinations. I think it is clear to everyone that this method is a worker.
Method 1: Insert special characters
The first method involves accessing the library with special characters available in Excel. It is necessary to find the necessary letters in it to denote any Roman numeral in their role. Let’s use a simple example to analyze the process of interacting with this table of special characters.
-
Go to the tab “Insert” and select an option “Symbol”.
-
A window will open in which I would recommend choosing a font “Verdana”. It is best for inserting Roman numerals, especially since it will immediately display the required characters in the list.
-
Find the components of the numbers and double-click on each of them to add to the letter in Excel.
-
Instead, you can highlight any letter and click “Insert” the required number of times.
-
Return to the book and note that all the characters were inserted within one selected cell in turn.
-
You can copy and paste them into other fields if you want to fill in several cells with Roman numerals.
However, nothing restricts you from using other special characters that are identical in appearance to Roman numerals. See the full list in the same window to find options in a different style and add them to your spreadsheet.
The community is now in the Telegram
Subscribe and stay up to date with the latest IT news
Sign up
Method 2: Convert Arabic numerals to Roman numerals
This method implies that you already have a number of numbers written in the usual way that need to be translated into Roman. Microsoft Excel provides a special feature that will speed up the process and allow you to do without manual conversion in the manner described above.
-
To begin with, figure out which cells with numbers to translate and select an empty column in front of them to write the function.
-
Then announce the feature = ROMAN ().
-
Click on the first cell with an Arabic numeral to highlight it for conversion. As a result, the function will look like = ROMAN (A1)where A1 – Your chosen cell with Arabic numerals.
-
Click Enter to apply the changes and see how Excel handled the transformation.
-
You can now left-click this cell on the lower right edge to drag down and stretch the function to the rest of the rows in that column.
-
The conversion will take place automatically and you will make sure that the function works correctly.
Use any of these methods, or refer to entering characters manually from the keyboard if it is also acceptable to you. Note that Roman numerals will be displayed as text, they cannot be used in other formulas or count.