Happy Boxing Day, All! I hope you are enjoying the holidays!
The old adage, “All work and no play makes Jack a dull boy”, is as true today as it was when it was first published in 1659. Therefore, this week’s blog is being devoted to 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.
Interestingly, there is a Roman Numeral function that is built-in to Excel. Why that Microsoft has done this is not entirely clear from a practical standpoint.
Practicality, of course, can be overrated, and it is readily apparent that Pro Football, Hollywood, and the Olympics have all used Roman numerals on a regular basis. If you also wish to do this sometime in Excel, (You can even use it for your next quarterly report to your boss, i individual has a really good sense of humor), you can use the ROMAN function.
Try it out! 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 needs someone to come up with the name for the next Super Bowl!
Wednesday, December 26, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment