Excel has a function for converting regular (Arabic) numbers to Roman numbers.


=ROMAN(number, type of conversion)


  1. Type =ROMAN(
  2. Select or type the cell reference that includes number in Arabic form B3,
  3. Type the conversion type, or omit C3
  4. Type ) and press Enter to complete formula


The ROMAN function can convert Arabic numbers to Roman in 6 different ways. These different types of conversion can be defined by its 2nd argument. However; to use its Classical type you can omit the argument.

There are 2 occasions both ROMAN function and actual Roman numbers are not supported:

  1. Negative numbers
  2. Numbers greater than 3999

On both occasions, the function returns #VALUE! error.