A little side-trick for converting text dates to Excel dates is replacing the text separator. Excel lets you replace text within the selected cells only. If the text dates are in the correct order (e.g. m/d/y ) but use the wrong separator for your Windows regional setting (e.g. m-d-y ). Excel’s Replace function will replace […]
Cymulate is reporting how embedded video in Word or other Office documents are another way for criminals and hackers to infect your computer. It’s yet another example of how Word, Excel or PowerPoint documents can be used to get malware onto computers to steal data, becomes bots or other nasties. This trick uses the relatively […]
Changing an Excel formula into the values is amazingly easy. It’s just a copy and special paste. Another way to think of it is deleting the formula but leaving the results in the cells. Select the cells. In this case from our article on converting text cells into Excel dates. Copy them, using Ctrl + […]
The 2018 Scrabble World Championship is over. How does the Microsoft Word spell check fare against the Scrabble champs? Microsoft Word has slightly different dictionaries for many English language variations (US, UK, Australian etc). Word’s English dictionaries different from the official Scrabble dictionary. Among the words in the final rounds were: Groutier Zonular Phenolic Maledict […]
A judgement from the US Court of Appeals turned on the Word Count feature in Microsoft Word and how it differs from the rules for court submissions. Most courts have rules about the length of submission which, in this case, were accidently exceeded. The plaintiff is representing himself (‘pro se’) so the judge was more […]
