TEXT practice

TEXT converts a number or date into text in a given format. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

TEXT(number, format)

What people get wrong

TEXT(date, "mmm yyyy") is a month label that groups correctly in a pivot or a report.

Google Sheets exercise that use TEXT

• Month label with TEXTLevel 5Pro