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 + […]
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 1 January to 1 February […]
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 Android. Icons are really SVG […]
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 a similar result by taking […]
We’ve added more to Real Time Excel, our comprehensive guide to adding the latest information into Excel easily and automatically. Real Time Excel already has in-depth coverage of Linked Data Types, a new and truly interesting addition to Excel for Windows. On 15 October 2018 we added a bit more to the already expansive coverage: […]
