Everything looks fine, except for one thing—your cells show the time and the data, which your boss simply doesn’t want. Most of the time (and that isn’t a pun), the time isn’t important, but the data value is. Since the timestamp contains both, Excel will display both, until you decide to remove the time manually. If you want to remove the time from a date in Excel, here’s what you’ll need to do....
Rename Kindle Fire Tablet On the next page, you get a list of the Kindle’s you’ve registered. Next to your device’s name, click Edit. Now type in what you want to name your Kindle in the field provided, then click Update. That’s it. Your Kindle Fire HD is renamed on the page, and the next time you turn on the device, you’ll see its new name. Scott Scott Comment Name * Email *...
If you’re using an Android phone, you might find that it’s actually pretty easy to recover a lost contact, but only if you’re quick enough. Most Android users store their contacts using their Google account, making it easy to restore a previously deleted contact. If you want to know how to restore deleted contacts on Android, follow this guide. How to Restore Deleted Contacts Using the Google Contacts App The best and easiest way to restore deleted contacts is to use the Google Contacts app....
When you boot into Safe Mode, it only loads what is necessary for Windows. No effects, no complex graphics driver, sound card, etc. This allows you to narrow down more easily what the issue you’re having might be. If you need to get to Safe Mode, here are a few ways to do it – from easy to more difficult. Note: You can also boot Windows 10 in Safe Mode....
Thankfully, typing arrows in Word can actually be remarkably easy, thanks to some handy shortcuts. You can even create your own shortcuts if there are specific arrow symbols that you intend to use regularly. If you’re ready to get to the point (pun intended) then here’s how to type arrows in Word. How to Type Arrows in Word Using AutoCorrect One of the quickest ways to type arrows in Word is to use the pre-defined AutoCorrect shortcuts....
But what about using zip files on a Chromebook? Here is a look at how you can zip or unzip files on your Chromebook with Chrome OS without using any third-party apps. Using Zip Files on Chromebook To create a zip file, open your Files app. Then head to the folder with the pictures, documents, or other files you want to zip up. Next, hold down the Ctrl key and click each file you want to add to your zip folder....
Here, we’ll walk through the basics of creating, editing, and applying labels in Gmail. Labels Versus Folders While labels in Gmail are similar to folders in other email applications, Google makes the difference clear. So, keep this dissimilarity in mind when working with labels in Gmail. Create a Label in Gmail You have a few places in Gmail where you can create a label. You can do so in your Settings, from the toolbar, or using the menu on the left....
You might want to find out who changed a formula, how long ago you added something, or even if a blank cell previously held data. Here’s how easy it is to view the edit history for a cell in Google Sheets. Edit History for a Cell in Google Sheets Head to the Google Sheets website, sign in, and open the workbook and spreadsheet you want to use. Next, select the cell, right-click, and pick Show Edit History from the shortcut menu....
Microsoft Update Adobe Flash Player Fix (KB3132372) According to Microsoft, this update fixes vulnerabilities in Adobe Flash Player in Internet Explorer and Microsoft Edge for Windows 10 Version 1151 (November Update). The affected software includes Flash Player in IE 10 and IE 11 in Windows 8, 8.1, RT, Server 2012, and Windows 10 as well as Microsoft Edge in Windows 10. Here’s the Microsoft support page summary: As always you’ll get this latest update automatically, but if you don’t want to wait, you can grab it manually by going to Settings > Update & Security > Windows Update....
You can redeem the offer by purchasing any number of selected DC Movies or TV shows from the Microsoft Store. Here is a full list of qualifying shows and there’s a lot of them. Of course, you just need to purchase one of them. Currently, the offer is only good for Xbox Live Gold members in the U.S. However, this is an interesting offer and will save you a few bucks on at least one ticket to the movie....
Powered by the new Intel 11th Gen Intel Core I7 processor (Tiger Lake) and its embedded Intel Iris XE GPU, the MSI Prestige 14 EVO (A11M-220US) is, hands down, the best business Ultrabook I’ve ever used. It’s fast, ultra-light, has a solid build design, and has plenty of battery life. Now, is it perfect? Of course not. Read on for all the details of what I both liked and disliked about the MSI Prestige 14 Evo during the past month of using it....
I’m usually good at finding an autoplay video and muting it via the player on the page or closing out of it. However, some are delayed, and you don’t hear anything. Also, many of the videos have a 30-second timeout while the next one is loading. So, you go to your next tab, and then another. You have a dozen tabs open, and then the audio starts playing, but you’re not sure which one it’s coming from....
The Carousel is at the top of your Kindle Fire home screen. There you can scroll through recently used items with a cover flow-like experience. To remove an item, tap and hold the item’s icon until the dialog appears. Then tap Remove from Home. You can also scroll over to the “For You” section, tap and hold an item, and tap Remove from Home” to get rid of it....
I later realized that probably wasn’t the best decision since my emails were showing up on the device, and she started calling asking to find out what is ‘screenshots for groovyPost article.’ So, I decided it was time to set up her own Gmail account, even if she was never gonna use it. I didn’t realize how not obvious it is to switch or remove existing accounts on Android. In this article, we’ll show you how....
Take a Snapshot in VLC Start playing a video in VLC. When you see a scene you want to capture, click Video » Snapshot. You briefly see a small thumbnail of the capture in the upper left corner of the screen. It also shows the directory the shot is stored in. By default, it’s saved in My Pictures as a PNG file. To have easier access to taking a snapshot, you can make an icon show up in the controls....
Slack maintains an app directory with all of the officially approved integrations, and on a free account, you are restricted to a maximum of ten integrations. But that restriction is removed on paid plans, and you can go integration-crazy. Choose the right ones, and you can have a productivity powerhouse in your Slack channels. What Is a Slack “Integration”? In Slack terms, an integration is similar to a browser extension or plugin....
Features Removed from Windows 10 21H1 Microsoft published a list of features that got deprecated or removed from the May 2021 Update, including Legacy Edge – support was ended on April 13th. And XDDM-based remote display driver. Here is the full list of removed features: Deprecated Features in Windows 10 21H1 This is a list of features the company has labeled as Deprecated. That means the company is still including them in Windows 10; however, it will not be working on them moving forward and are more than likely on the path to be removed in the future....
The UI changes are slight but very useful. I don’t know about you but I really got sick of scrolling down to the bottom of the conversation every time I needed to reply to an email. Not to mention it always seemed like I had to tap the button twice before my reply box would even open. That’s all solved with this updated version. Check out the quick screenshot tour below for all my favorite updates from the release!...
See Passwords Behind Asterisk in Google Chrome Open any website where you have your password saved, right-click on the password field and go to Inspect Element. When the HTML Editor opens, look for input type = “password” field and change “password” to “text” and press Enter to save. An easy way to find that line of code is to hit Ctrl + F and type: password in the search field and arrow to it....
Eighteen-year-old Amr Mohamed came up with the idea of observing spiders catch prey in zero gravity to answer the question, “Can you teach an old spider new tricks?” Being of age, Amr immediately engaged in cosmonaut training in Star City, Russia, as part of the prize. The other winner was a team of two 16-year-olds, Dorthy Chen and Sara Ma. They were curious to understand how bacterial growth worked in zero gravity....
