Using the Excel ROMAN and ARABIC Functions

[@elinat6993]

This is an opportunity! Thanks!

[@kelleyhartshorn4342]

Thank you for this, very helpful and informative.

[@tedhead3162]

That was most interesting! Thank you 🧤

[@enochjnr6341]

Thank you

[@eldarabdullayev1]

nice

[@rohateanonis4657]

Great vid. But I really want to know why the function is called arabic cuz I can read and write arabic and that aint arabic.

[@infamous8541]

those are hindu-arabic numerals

[@rohateanonis4657]

@@infamous8541 neither of their numerals look like the English ones Probably bad naming

[@hamzanasir6553]

Great job

[@flash24g]

The funny thing is that the numerals we generally use are called Arabic or Hindu-Arabic numerals. Sometimes Western Arabic numerals to distinguish these symbols from those actually used in Arabic. But essentially, the name denotes the place value system. But in any case, the function is misnamed because it returns a numeric value, not a string of digits.

[@privacyvalued4134]

What weird functions. I can't think of a single legitimate use case for either of these functions in Excel. If someone out there is actively using Roman numerals, then they are doing numbers wrong. Also, the ROMAN() function in Excel has a bizarre maximum input value of 3,999 while ARABIC() translates Roman numerals up to 255,000. My best guess is that these useless functions are vestiges leftover from the early days of Excel when it was competing with VisiCalc and Lotus 1-2-3 and other early spreadsheet programs and they wanted to maximize compatibility. Microsoft probably decided to clone those functions despite the Roman Empire having been defunct for over 1500 years.