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 ).
A badly managed switch to Office 365 made it hard for staff and passengers at London’s Victoria Station. An uninstall message for Office 2010 appeared over the important platform display. The Register reports that the platform status displays, not the main board were hard to read because an Office 365
Yet another breakdown of Office 365 servers makes like difficult for customers. Users were unable to login with their Office apps or to Microsoft hosted Exchange Servers. It’s not clear how widespread the problems were. It happened on 31 October 2018 but took twelve hours to repair. That’s a disappointingly
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.
Office 365 enterprise customers will soon receive tips emails from Microsoft directly and without ‘opting in’. Microsoft calls them “helpful product training and tips” but aren’t being greeted with the enthusiasm that the company might be expecting. They’re reported to be starting on 29 November 2018 to all Office 365
Speed Running, a gamers pastime has come to Microsoft Word. Finding ways to type the numbers 1 to 100 in the fastest time. If you’re unfamiliar with speed running, as we were, it’s playing and recording a pass through a game aiming to complete as fast as possible. Someone came
A new email trick to fool people into clicking a link from Outlook. It’s a ‘warning’ that your mailbox is near it’s size limit. The message was a little sophisticated by pretending to come from the real company that handles the domain. It was sent to an address with a
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.
The new iPad Pro’s announced today by Apple come with an extra cost to use Microsoft Office. Office Mobile apps for iPad are usually free for everyone. There are some extras for Office 365 customers but most of the app features are available for all comers. But the new iPad
The Office Home Use Program (HUP) is a cheap way to buy Office 2019 but there are some downsides. Your money might be better used for an Office 365 Home or Personal plan. The Home Use Program product is very limited in both features and how many computers you can
We clear up some of the misunderstandings about the MS Office Home Use Program (HUP), one of the cheapest ways to buy Microsoft Office. In our article Home Use Program or getting Microsoft Office for $15 we explained how many companies can let their staff buy Office 2019 for Windows
The cheapest legal way to get Microsoft Office is the Home Use Program (HUP). It costs just $15 each for Office 2019 Windows or Mac. Like many Microsoft deals, it’s not as good as in the past, but it’s still cheap and worth considering. Many people qualify for the Home
It was inevitable that scammers would start using Office 365 as the basis for email scams, here’s what to look out for and how to avoid any dangerous web links. The scams are similar to the fake emails that pretend to come from banks and other large companies. They try
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
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’)
Adding or subtracting months in Excel is easier with the Edate() function. As you probably know, Excel uses whole numbers to calculate dates. Add 1 to an Excel date adds a day. How to add a whole month? How to make Excel jump a whole calendar month? For example from
It was surprising and frankly disappointing to see Amazon USA post a very dubious offer for Office 2019 Professional Plus at just US$46.99. Office 2019 Professional Plus sells for around $559 but only as a volume licence. There’s no retail version of Office 2019 Professional Plus. This offer is doubly
Various ‘news’ stories going around promising a trick to getting Office 2019 for free … don’t believe it. We know a way to get Office 2019 cheap, but not free. Maybe these ‘Office 2019 for free’ stories are deliberate clickbait or horribly ill-informed, either way they’re quite wrong. As often
Microsoft has released Office 2019 for Windows or Mac to the Home Use Program. Just $15 gets qualifying employees Office 2019 Professional Plus for Windows or Office 2019 Home and Business for Mac. The Home Use Program (HUP) is part of the Software Assurance package for Volume Licence customers. Employees
Microsoft has added the Dictation feature to the browser based versions of Word and OneNote. You can speak and words will appear in Word/OneNote using the cloud ‘speech to text’ feature. Source: Microsoft Dictation is already available in Word 365 for Windows. Office for Mac users have a ‘voice to
Office for iOS (iPhone / iPad ) is getting the Icons or SVG support already available in Word 365 for Windows. Icons now available to Office iOS Insiders on the Insert tab. There are 500 to choose from … Source: Microsoft Available in the Word, Excel and PowerPoint apps for
Excel for Android is getting the ability to insert numbers and text from a picture. Insert | Data from Picture is now available to Office for Android Insiders and will rollout to the public in coming months. It’s OCR (Optical Character Recognition) specialized for Excel. Source: Microsoft You can get
Coming to Word 365 for Windows are more Ink Editor gestures plus a pop-out pane to explain the gestures available. Ink Editor is on the Draw menu. It’s a way to use a digital pen to edit existing text. For example, draw a squiggly line through some words to delete
Microsoft Office for Windows is gradually changing the software name to Office 365 . It’s being done slowly, almost by stealth but it’s happening. Keen eyed readers have noticed a gradual change on the Microsoft web site and software. We first mentioned it back in August 2018 but the software
