Fresh Excel Tips

This tip explains how to convert an Arabic numeral to a Roman numeral. To get this result, use the ROMAN function, which returns the Roman value as text. Here is the syntax that is used:

ROMAN(number, form)
number: The Arabic numeral to be converted.
form: (optional) A number from 0 to 4 that specifies the type of Roman numeral. Styles range from Classic to Simplified and become more concise (using fewer characters) as the value of form increases. If omitted, the Classic type is used.

To convert Arabic numerals to Roman numerals:

1. In cells A2:A10 enter valid numbers from 1 to 3999.
2. Select cells B2:B10 and type the following formula: =ROMAN(A2,0).
3. Press Ctrl+Enter.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. How to Check for Valid Numbers Using the T Function in Excel
2. How to Use the FIXED function to round and convert numbers
3. How to Use the TIMEVALUE function to convert text to time
4. How to convert invalid numbers to valid numbers in Excel
5. How to Use the ROUNDDOWN function to round numbers down