Home

How to Use TEXT & custom number formatting in Microsoft Excel

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)

Apple's iOS 26 and iPadOS 26 updates are packed with new features, and you can try them before almost everyone else. First, check Gadget Hacks' list of supported iPhone and iPad models, then follow the step-by-step guide to install the iOS/iPadOS 26 beta — no paid developer account required.