Just for Fun…

Once in a while, even an Advanced Excel User should have a bit of Geeky Fun. Although of no real Practical use, it can be interesting, (once again, in a geeky sort of way), to play around with Roman Numerals. Even for an Excel guru, it may be surprising to find that the application has a built-in Roman numeral function.

Practicality, of course, can occasionally be overrated, and it is readily apparent that Hollywood, Football, and the Olympics have all used Roman numerals on a regular basis. If you also wish to do this sometime in Excel, (I probably wouldn’t recommend it for your next quarterly report to your boss, unless the individual has a really good sense of humor), you can use the Roman function.

For a Classic Numeral, (other formats are available, but who needs them…), simply enter a value in cell A1 and type, “=Roman(A1)” in cell B1. Hit Enter and Presto, a Roman numeral of the A1 number!

Now you will be all set if the NFL or Olumpics needs someone to come up with the name for the next Major Event!