Home

How to Use TEXT & custom number formatting in Microsoft Excel

May 6, 2010 09:57 PM

Spreadsheet showing Excel formulas and data formatting options.

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:

1) Format cells

2) Format formula input numbers to show a label with custom number format

3) TEXT function used with text formulas to create labels

4) TEXT function to create TRUE/FALSE formulas to check whether criteria is met

5) Count number of dates in a data set that meet criteria (certain month)

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.