# Google Sheets TO_TEXT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/totext-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) Converts a numeric value to a text value. ``` =TO_TEXT(value) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the TO\_TEXT you need in plain EnglishGenerate Formula ## Parameters | Parameter | Required | Description | | - | - | - | | **value** | Yes | The value or cell reference to convert to text. Numbers become text strings; text is returned unchanged. | ## What Is TO\_TEXT? TO\_TEXT converts a number into text. The result looks the same, but Sheets now treats it as a string: it left-aligns by default, it is ignored by SUM and other numeric aggregates, and it can be compared with other text values exactly. When you point TO\_TEXT at a cell, it uses the cell's displayed formatting. If A2 holds 0.25 formatted as a percentage, `=TO_TEXT(A2)` returns the text "25%"; if A2 holds a date, you get the date as it appears in the cell rather than its serial number. ## Why Convert Numbers to Text? - **Matching IDs**: Lookups fail when one table stores an ID like 10045 as a number and the other as text. Converting both sides to text makes them match. - **Preserving how a value looks** when joining it into labels. - **Keys and concatenated codes**: Building composite keys such as `=TO_TEXT(A2)&"-"&B2`. - **Exporting**: Some downstream systems need text fields. ## Basic Examples ### Convert a number ``` =TO_TEXT(42) ``` Returns the text "42". `=ISTEXT(TO_TEXT(42))` returns TRUE. ### Fix a lookup type mismatch ``` =VLOOKUP(TO_TEXT(A2), Products!A:C, 3, FALSE) ``` Looks up a numeric ID in a table where IDs are stored as text. ### Keep a cell's formatting in a label ``` ="Completion: "&TO_TEXT(B2) ``` If B2 is formatted as 87.5%, the label reads "Completion: 87.5%". Without TO\_TEXT, concatenation uses the raw value 0.875. ### Convert a whole column ``` =ARRAYFORMULA(TO_TEXT(A2:A500)) ``` ## TO\_TEXT vs. TEXT | | TO\_TEXT | TEXT | | - | - | - | | Arguments | Just the value | Value and a format pattern | | Formatting used | The source cell's existing display format | The pattern you supply, e.g. `"0.00"`, `"yyyy-mm-dd"` | | Best for | Quick type conversion, keeping what you see | Precise control over output | If you need a specific look regardless of the source cell's formatting, use `=TEXT(A2, "$#,##0.00")`. If you just need "the same thing, but as text", TO\_TEXT is simpler. ## Converting Back To turn text back into a number, use VALUE (parses text such as "1,200" or "25%"), or [TO\_PURE\_NUMBER](https://betteranalyst.com/google-sheets/topurenumber-function) to strip formatting from a numeric value. Multiplying by 1 or adding 0 also coerces numeric-looking text in most formulas. ## Common Use Cases - **Joining data from different sources** where one exports numbers and another exports text. - **Building labels and descriptions** that keep currency, percent or date formatting. - **Creating unique keys** for deduplication or VLOOKUP/XLOOKUP joins. - **Preserving leading zeros** is *not* something TO\_TEXT does on its own — a number like 00123 is already stored as 123. Use `TEXT(A2, "00000")` for fixed-width codes. ## Common Errors - **SUM returns 0**: The column was converted to text. Aggregate the original numbers, or convert back with VALUE. - **Unexpected format in the result**: TO\_TEXT copies the source cell's display. If you get "1.2E+10", the source is formatted in scientific notation; change the cell format or use TEXT with an explicit pattern. - **Lookup still fails**: Check for stray spaces with TRIM, and make sure both sides are the same type. ## Tips and Best Practices - Convert at the point of comparison (inside the lookup) rather than converting entire data columns. - Use TEXT when the output format must be guaranteed. - After converting, test with ISTEXT if you're unsure what type you have. ## Related Functions TEXT, VALUE, [TO\_PURE\_NUMBER](https://betteranalyst.com/google-sheets/topurenumber-function), [TO\_DOLLARS](https://betteranalyst.com/google-sheets/todollars-function), [TO\_PERCENT](https://betteranalyst.com/google-sheets/topercent-function), [TO\_DATE](https://betteranalyst.com/google-sheets/todate-function), and ISTEXT. ## Example use case An e-commerce analyst's order export stores product IDs as numbers, but the catalogue sheet stores them as text, so VLOOKUP returns #N/A. Rewriting the lookup as =VLOOKUP(TO\_TEXT(A2), Catalogue!A:D, 2, FALSE) makes the types match and every product name appears. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Make A Histogram In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-histogram-in-google-sheets) - [How To Make A Line Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-line-graph-in-google-sheets) - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) - [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets) - [How To Multiply In Google Sheets](https://betteranalyst.com/google-sheets/how-to-multiply-in-google-sheets) - [How To Password Protect An Google Sheets File](https://betteranalyst.com/google-sheets/how-to-password-protect-an-google-sheets-file) - [How To Remove Blank Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-blank-rows-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.