Convert Numbers to Roman Numerals

Microsoft Excel has a built in ROMAN Function that will convert arabic numbers to their Roman Numeral equivalents.

The output is text based and not number based.

In my example I have a list of numbers in column A starting with 1 and going to 24. In cell B1 type the following Function:

=ROMAN(A1)

excel-convert-number-to-roman-numeralThen simply pull this function down until you reach row 24. You should then have the arabic numbers displayed in column A and their Roman numeral equivalents in column B.  Quick and easy!!

I wish I knew about this when I was learning Roman Numerals at school!!

One thought on “Convert Numbers to Roman Numerals

  1. Pingback: Tweets that mention Excel Help | Convert Numbers to Roman Numerals | Microsoft Excel Formula, Functions, Macros & VBA -- Topsy.com

Leave a Reply

Your email address will not be published. Required fields are marked *