Welcome to Excel Jet Consult blog post. In this tutorial we will learn how write numbers in Roman Numerals. Let’s get started.
ROMAN Function converts an Arabic numeral to Roman as text
ROMAN Syntax =ROMAN(number, [form])
In the caption below, we want to display all the numbers in column A in Roman Numerals
In cell B2, execute the formula: =ROMAN(A2)
We can see from the caption below that the Roman Numeral for 1500 is MD