• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

convert roman numerals to numbers

Peter Bartholomew

Well-Known Member
Since this thread has come to life, I have also constructed a (complex) solution using Excel 365 beta. I did this by using a recursive Lambda function.

To invoke the Lambda function one uses formulae of the type

[the attached file is a macro file because there is a VBA utility to upload the Lambdas to Name Manager]

The way Excel is developing, we may soon reach the point at which the fact that it also implements the conventional spreadsheet paradigms is a mere curiosity for the traditionally minded.