---
title: "TEXT in Google Sheets: syntax and examples | ExcelSavvy"
description: "Formats a number as text with a number format code, for example to put it inside a sentence. With examples and exercises in Google Sheets."
canonical_url: "https://excelsavvy.com/sheets/functions/text"
meta:
  "og:description": "Formats a number as text with a number format code, for example to put it inside a sentence. With examples and exercises in Google Sheets."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VEVYVCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~Rm9ybWF0cyBhIG51bWJlciBhcyB0ZXh0IHdpdGggYSBudW1iZXIgZm9ybWF0IGNvZGUsIGZvciBleGFtcGxlIHRvIHB1dCBpdCBpbnNpZGUgYSBzZW50ZW5jZS4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzIGluIEdvb2dsZSBTaGVldHMu%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VEVYVCh2YWx1ZSwgZm9ybWF0X3RleHQp%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3RleHQi%2Cs_aykFKMPfP5tsYecc.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "TEXT in Google Sheets: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VEVYVCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~Rm9ybWF0cyBhIG51bWJlciBhcyB0ZXh0IHdpdGggYSBudW1iZXIgZm9ybWF0IGNvZGUsIGZvciBleGFtcGxlIHRvIHB1dCBpdCBpbnNpZGUgYSBzZW50ZW5jZS4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzIGluIEdvb2dsZSBTaGVldHMu%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VEVYVCh2YWx1ZSwgZm9ybWF0X3RleHQp%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3RleHQi%2Cs_aykFKMPfP5tsYecc.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **TEXT in Google Sheets**

Formats a number as text with a number format code, for example to put it inside a sentence.

=

TEXT(

## **In Google Sheets**

TEXT works as in Excel and takes the same format codes, such as "0%", "#,##0.00" and "mmm d, yyyy". Google Sheets reads the codes in English whatever the spreadsheet's language, so the year is always yyyy.

## **Syntax**

```
TEXT(value, format_text)
```

<dl><dt>**value **</dt>
<dd>The number or date to format.</dd>
<dt>**format_text **</dt>
<dd>A format code in quotes, such as "0%", "00000" or "dd-mm-yyyy".</dd></dl>

## **Examples**

B1`=TEXT(<sup>1</sup>0.25,<sup>2</sup>"0%")`

|  | A | B |
| --- | --- | --- |
| 1 |  | **25%** |

**In plain words:** Show <sup>1</sup>0.25 <sup>2</sup>as a percentage with no decimals.

B1=TEXT(42,"00000")

|  | A | B |
| --- | --- | --- |
| 1 |  | **00042** |

B1=TEXT(1234.5,"#,##0.00")

|  | A | B |
| --- | --- | --- |
| 1 |  | **1,234.50** |

B1=TEXT(DATE(2024,3,5),"dd-mm-yyyy")

|  | A | B |
| --- | --- | --- |
| 1 |  | **05-03-2024** |

## **Related functions**

- [**CONCAT**](https://excelsavvy.com/functions/concat)
- [**TEXTJOIN**](https://excelsavvy.com/functions/textjoin)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/sheets/functions/text#webpage","@type":"WebPage","dateModified":"2026-11-16","description":"Formats a number as text with a number format code, for example to put it inside a sentence. With examples and exercises in Google Sheets.","name":"TEXT in Google Sheets: syntax and examples","url":"https://excelsavvy.com/sheets/functions/text","breadcrumb":{"@id":"https://excelsavvy.com/sheets/functions/text#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/sheets/functions/text"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/sheets/functions/text#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Google Sheets practice exercises","item":"https://excelsavvy.com/sheets","position":2},{"@type":"ListItem","name":"TEXT in Google Sheets: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/sheets/functions/text#article","dateModified":"2026-11-16","description":"Formats a number as text with a number format code, for example to put it inside a sentence. With examples and exercises in Google Sheets.","headline":"TEXT in Google Sheets: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VEVYVCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~Rm9ybWF0cyBhIG51bWJlciBhcyB0ZXh0IHdpdGggYSBudW1iZXIgZm9ybWF0IGNvZGUsIGZvciBleGFtcGxlIHRvIHB1dCBpdCBpbnNpZGUgYSBzZW50ZW5jZS4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzIGluIEdvb2dsZSBTaGVldHMu%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VEVYVCh2YWx1ZSwgZm9ybWF0X3RleHQp%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3RleHQi%2Cs_aykFKMPfP5tsYecc.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/sheets/functions/text#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/sheets/functions/text#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VEVYVCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~Rm9ybWF0cyBhIG51bWJlciBhcyB0ZXh0IHdpdGggYSBudW1iZXIgZm9ybWF0IGNvZGUsIGZvciBleGFtcGxlIHRvIHB1dCBpdCBpbnNpZGUgYSBzZW50ZW5jZS4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzIGluIEdvb2dsZSBTaGVldHMu%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VEVYVCh2YWx1ZSwgZm9ybWF0X3RleHQp%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3RleHQi%2Cs_aykFKMPfP5tsYecc.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VEVYVCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~Rm9ybWF0cyBhIG51bWJlciBhcyB0ZXh0IHdpdGggYSBudW1iZXIgZm9ybWF0IGNvZGUsIGZvciBleGFtcGxlIHRvIHB1dCBpdCBpbnNpZGUgYSBzZW50ZW5jZS4gV2l0aCBleGFtcGxlcyBhbmQgZXhlcmNpc2VzIGluIEdvb2dsZSBTaGVldHMu%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VEVYVCh2YWx1ZSwgZm9ybWF0X3RleHQp%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3RleHQi%2Cs_aykFKMPfP5tsYecc.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
