Via Clive Thompson’s latest Linkfest, we are directed to towards a hidden reliquary of old, obscure Microsoft Excel functions maintained update after update to preserve compatibility and integrity of spreadsheet data—some being very dated like the ticker-tape age DOLLARDE and DOLLARFR when stocks and bonds were quoted in fractional dollars pre-decimalisation or highly specific like ROMAN which converts Arabic numerals, mainly for decorative use only as they are not well suited to double-entry bookkeeping (see also) and BAHTTEXT that transforms a value spelled out in Thai Baht, introduced in accordance with the country’s invoicing standards that require numbers expressed both ways to ensure clarity. Like the way the amount on a cheque is written out in long form, Excel only offers this feature for Thailand, which isn’t the only jurisdiction that requires it.
synchronoptica
one year ago: a virtual Advents Calendar of work entering the public domain (with synchronopticรฆ), Saint Zephania plus a game of incense
thirteen years ago: combatting youth unemployment, a post-industrial revolution plus a Lt Uhura My Little Pony
fifteen years ago: extremophiles
sixteen years ago: holiday shopping
seventeen years ago: authorised delay











