9 lessons in order
The number format in Google Sheets is used to control the appearance of the numerical values in cells. It lets us customize the number format with decimal, percentage, fraction, currency and more. There are several types of default formatting options associated with the number format in Google Sheets. We can also create a unique number […]
Learn how to use custom number formats in Google Sheets to add leading zeros, currency, units, abbreviations, and highlight negative numbers.
Learn how to format numbers as millions in Google Sheets with custom formats, helper columns, and the TEXT function.
Learn how to change negative numbers to positive in Google Sheets using ABS, IF, -1 multiplication, ARRAYFORMULA, Find and Replace.
Learn how to format phone numbers in Google Sheets using apostrophes, Find and Replace, or Custom Number Format for a clean, uniform look.
Learn how to change number formats in Google Sheets, including text conversion, time, duration, decimals, and custom formatting examples.
Learn how to convert text to numbers in Google Sheets using VALUE, REGEXREPLACE with VALUE, ARRAYFORMULA, or simple multiplication by 1.
Learn how to convert numbers to text in Google Sheets using TO\_TEXT, TEXT function, or Google Apps Script to display values as words.
Learn two easy ways to make negative numbers red in Google Sheets using conditional formatting or custom number formats.