Formulas > =TEXT()
How to Use TEXT() in Google Sheets
Description
How To Actually Use TEXT() in Sheets
TEXT(number, format)
Try TEXT yourself
In cells B1:B10, convert the numbers in cells A1:A10 to text format with two decimal places. Your formula should display the numbers as text.
Hints (2)
-
Remember to use the correct format for two decimal places.
-
The TEXT function requires both a number and a format string.
Better Sheets Tutorial
Ben Asks: How Do I Add 1 Month?
Member Ben asks how to add 1 month to a date.
Daily Writer's Word Count Tracker
Walk through creating an awesome automatic word count tracker that's easy to use and motivates the writer to keep going. With AI generated quotes from famous writers, along with simple formulas to generate states along the way.
Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales
Analyze sales with COUNTUNIQUEIFS Formula.
More related tutorials
Transcript-matched member videos for TEXT(). Click through to watch.
Your First Formula
Move Cells to New Row with Formula
Write Apps Script to Create a New Google Sheets Formula
Learn more about the TEXT() formula:
Generate a TEXT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses TEXT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a TEXT() formula