Formatting

Sometimes when working in Google Sheets you may want to replace a space with something like a dash. This is very easy to do with the find and replace feature. …

When working in Google Sheets, there may be times when you want to keep leading zeros in a number. It can be frustrating to find that Google Sheets will automatically …

When working with time values in Google Sheets, there may be times when you want to convert time to decimals. Working with decimals is often required when you need to …

Sometimes when working in Google Sheets, you may want to convert a month name to a number. For example, maybe you have a cell that contains a month like “September” …

Sometimes when working in Google Sheets, you may need to take a timestamp and extract the date from it. Luckily this is a pretty simple process. In this tutorial, I …

If you want to convert to military time in Google Sheets, you can do so pretty easily with some of their built-in features. In this tutorial, I will show you …

Google Sheets has a ton of useful features that many users don’t know about. One such feature is the ability to easily alternate row colors by highlighting every other row …

Sometimes when working in Google Sheets, you may want to create a numbered list inside your spreadsheet. To do this, you have a few options. You can create a numbered …

As you working with spreadsheet programs like Google Sheets, you will likely eventually find unwanted extra spaces in your cells. This could be leading spaces that occur at the beginning …

Sometimes when working in spreadsheet programs, the data in your cells may look uneven and sloppy if cells have different formatting rules applied to them. Learning to justify the text …