How to Use TO_TEXT() in Google Sheets

Description

Converts a provided numeric value to a text value.

How To Actually Use TO_TEXT() in Sheets

TO_TEXT(value)

Try TO_TEXT yourself

In cells B1:B10, convert the numeric values from cells A1:A10 to text format using the TO_TEXT formula.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for TO_TEXT(). Click through to watch.

Browse more tutorials

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Create Hundreds of Tweets in a Google Sheet

Write tweets fast! Create hundreds of tweets in a Google sheet with ease...

Embed a Headline in a Website from Google Sheets

One of the most requested videos, Ever. How to put data, a number, some ...

Advanced

SUBSTITUTE()

Unlock these tutorials

Learn more about the TO_TEXT() formula:

Generate a TO_TEXT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses TO_TEXT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a TO_TEXT() formula