This is a rudimentary conversion of ROMAN numerals to ARABIC (opposite of ROMAN() function from Excel 2010). It could be improved, of course, but it does its job for the classic Roman numerals.
Use it as: ARABIC("Roman Numerals")
Paste the code into a new module and in excel cell, type =ARABIC("xxx") (where xxx is the Roman numeral)
Bookmarks