How to Stop Excel from Removing the Second Decimal Place If It’s a Zero

how to always show two decimal places in excel, even if the second number is a zero

Excel 2013 has a wide range of formatting choices that can be applied to cells in a worksheet. But some of the default formatting choices can be frustrating to deal with, especially when you need your numbers to display a certain way. One … [Continue reading]

How to Set the Home Page in the Firefox iPhone Browser

how to change the homepage in the iPhone firefox app

The Safari browser on your iPhone is deeply ingrained into the functionality of your iPhone, and is generally a fast and responsive browser. But if you use a third-party browser on your laptop or desktop computer, and you have an account with the … [Continue reading]

How to Add a Caption to a Table in Word 2013

how to insert a table caption in word 2013

Large documents can be tough to navigate. Pages can start to run together, and similar sections may be difficult to identify separately from one another. This can be even more pronounced when you include a lot of tables in your document, especially … [Continue reading]

How to Send an Animated GIF in a Text Message on an iPhone 7

how to send an animated gif in a text message on an iphone 7

The Messages app received a lot of new features with the iOS 10 update, including the ability to send animated GIF files via text message or iMessage. Animated GIF files are a special type of image file that can cycle between multiple image "frames" … [Continue reading]

Hostgator vs Bluehost – Hosting Comparison Using the Same Site on Both Hosts

syttestb-pingdom-test

When you are looking for a hosting company for your new website, there are a lot of different options available to you. But two of the most common options you will encounter are Hostgator and Bluehost. They are two of the largest companies that offer … [Continue reading]

How to Download a Netflix TV Show Episode to Your iPhone

how to download a tv show episode in the iPhone netflix app

One of the biggest complaints from Netflix users used to be the inability to watch content offline, but that complaint has now been alleviated. iPhone Netflix users can now download videos directly to their iPhones, which they can then view without … [Continue reading]

How to Make the Apple Watch Screen Brighter

how to increase brightness on the apple watch

The battery on your Apple Watch is able to last a couple of days with normal usage. This average usage time can vary, depending upon a number of different factors. One of these factors is the brightness of the screen. Powering the illumination of the … [Continue reading]

How to Display a “0” Instead of #N/A When Using VLOOKUP in Excel 2013

how to display a zero instead of #n/a in excel 2013 vlookup formula

The VLOOKUP formula in Microsoft Excel is one of the most efficient ways to find data in spreadsheets. It can save an incredible amount of time when compared to manually searching for cell data, and has the added benefit of being repeatable and … [Continue reading]

How to Use the Reading List in Safari on Your iPhone 7

how to use the iphone safari reading list

You probably encounter Web page links in a number of different ways throughout the day. They can come via email, in social media, or simply as you enter search terms into Google. You might want to read a lot of the information that these links … [Continue reading]

How to Remove the First Character from a Cell in Excel 2013

how to remove the first character from a cell in excel 2013

A lot of data that you encounter will not be formatted the way that you need it. Whether a colleague likes to add a space or a special character in front of data that they type, or they do unusual things with their information to make it sort a … [Continue reading]