David Benaim does it successfully on YouTube and at the Edinburgh Festival.
Matt Parker does it as a very popular stand-up comedian and bestselling author.
I’ve tried to be funny about Excel a couple of times on this blog. Then Microsoft has updated Excel to actually implement my satirical suggestions. It’s hard to be funny when real life imitates art.
CPP() is almost real
What Excel really needs is a way of executing a proper language, within the constraints of a normal formula.
For the benefit of any Excel fans who aren’t also experienced programmers, CPP() was intended to refer to the C++ (“C plus plus”) programming language, which is famously difficult and unforgiving.
But then along came Microsoft and added the PY() function. Admittedly, this runs Python code in a cloud context rather than within the spreadsheet, but it’s very much in the spirit of my ridiculous suggestion.
Here’s how Microsoft introduces the PY() function in their official documentation:
After entering =PY into a cell and selecting the PY function from the AutoComplete menu, the cell editing experience transforms into a Python editor.
Please, do enjoy your transformational “cell editing experience”.
ROMAN() can be reversed
There’s no function for converting a Roman numeral string back into conventional Arabic digits – so having converted a number to Roman, it can’t be processed any further.
This was true when I blogged about it, but in fact hasn’t been true since Excel 2016, when Microsoft introduced the ARABIC() function which converts Roman numerals back to Arabic. I also wrote with heavy sarcasm:
There’s a bewildering array of optional arguments that return strings in different forms, most of which, I suspect, wouldn’t mean much to a real Roman.
And yet, here is an extract from Microsoft’s documentation for the ARABIC() function:
Although a negative Roman number is non-standard, evaluation of a negative Roman numeral is supported. Insert the negative sign before the Roman text, such as “-MMXI.”
As I say, satire is hard.
BAHTTEXT() has its uses
I wrote about BAHTTEXT() as a baffling function in the context of it being unique in Excel – a function that both converts a number into a currency and translates it into another language. But now the aforementioned David Benaim has come up with a legitimate use for this esoteric function and I genuinely can’t tell if he’s being entirely serious.
This is the technique that David presented at the EuSpRIG 2025 conference:
Suppose we want to convert a number, say 126, into the text “one hundred and twenty-six”. We can couple the ancient BAHTTEXT() with a series of new-ish Excel functions to do the conversion.
- Use BAHTTEXT() to convert the numeral into Thai: หนึ่งร้อยยี่สิบหกบาทถ้วน (bonus points if that script renders correctly in your web browser).
- Use the new TRANSLATE() function to convert this to English via a cloud translation service: One hundred and twenty-six baht
- Use the new TEXTBEFORE() function to take all of the text before the word “baht”.
The resulting formula will look something like this:
=TEXTBEFORE( TRANSLATE( BAHTTEXT(A1) ), " baht" )
… and one near miss for CELLFORMAT()
With tongue firmly in cheek, I wrote:
What if you want to change the contents of the cell based on its formatting?
Excel’s CELL() function almost does this. It can return information about the number format of a cell (such as red for negative values), along with information about the type of data and any cell protection. Alas, it stops short of providing detailed user formatting and so cannot be used to apply business logic on the basis of visual style. So it’s not yet possible to throw Excel into a tailspin by setting a conditional format that changes the cell’s value, thus changing the applied format, ad infinitum.
But Excel is constantly evolving. Maybe next year?
