by Oluwaseun Olatoye | Feb 28, 2022 | Functions
This post is going to show you all the ways you can change negative numbers into positive numbers in Google Sheets. Perhaps you have a price list with negative numbers in it. Since negative prices are obviously an error, you may need to fix them by changing the number...
by Lalit Salunkhe | Feb 27, 2022 | Functions
This post is going to show all the ways you can use to convert temperature values between Celsius and Fahrenheit measurement in Google Sheets. When you are working with data that consists of temperature values, it is sometimes needed to convert the data from Celsius...
by Oluwaseun Olatoye | Feb 18, 2022 | General
This post will show you all the ways you can use to randomize the sort order of your data in Google Sheets. Sorting data helps to organize or arrange a dataset in a specific order. In Google Sheets, you can sort text and numeric values in ascending or descending...
by Lalit Salunkhe | Feb 17, 2022 | Apps Scripts
This post is going to show you all the ways you can get the quarter from a date value in Google Sheets. Getting the quarter from a date value can be crucial for many businesses since results are often summarized by quarter. Extracting the Quarter from a date is tricky...
by Oluwaseun Olatoye | Feb 16, 2022 | Format
This post is going to show you all the ways you can display your zero values as a dash or hyphen in Google Sheets. Does the number zero appear often in your dataset, and do you want to display them in a way to differentiate them from other values? Zero means the...