How is TO_TEXT different from formatting a cell as text?

TO_TEXT converts the value itself to text type, while cell formatting only changes how the value appears visually. TO_TEXT ensures the actual data is text, which affects sorting, filtering, and formulas downstream.

Does TO_TEXT remove decimal places or formatting?

No, TO_TEXT preserves the exact value as-is and simply converts it to text format. A numeric 385.50 becomes the text "385.50", maintaining all precision and decimal points.

Can I use TO_TEXT on cells that are already text?

Yes, TO_TEXT on text cells returns the same text unchanged. This is useful for standardizing mixed-type data or ensuring consistency when combining data from multiple sources.

When should I use TO_TEXT instead of just typing the value as a string?

Use TO_TEXT when converting dynamic values (cell references, formula results, or lookup outcomes) to text, especially in reports where you need the result to adapt as source data changes.

TO_TEXT function

Converts a value to text format, returning its content as plain text regardless of the original data type or formatting.

=TO_TEXT(value)

Generate a TO_TEXT formula

Describe what you need. The generator will reach for TO_TEXT where TO_TEXT is the right tool, and tell you when it is not.

Arguments

How TO_TEXT reads its arguments

Argument	Required	Description
value	Required	The value to convert, which can be a number, date, boolean, cell reference, or formula result; TO_TEXT processes any data type and always returns text.

Returns

Returns a text string representation of the input value.

Availability

Excel: Not available · Google Sheets: Supported

Worked examples

1. Convert budget amount to text

Category	Month	Budgeted
Groceries	January	400
Utilities	January	150

=TO_TEXT(C2)

Result: "400"

TO_TEXT converts the numeric budget value 400 to the text string "400". This is useful when you need to combine budget numbers with text in labels or when ensuring a value is stored as text for text-based operations.

2. Convert variance calculation to text

Category	Actual	Budgeted
Groceries	385.5	400
Utilities	165	150

=TO_TEXT(D2-C2)

Result: "-14.5"

When calculating variance (actual minus budgeted), TO_TEXT converts the numeric result -14.5 to text. This preserves the calculated value in text format, useful for creating reports where variance amounts need to be treated as text strings.

3. Convert result of comparison to text

Category	Actual	Budgeted
Entertainment	245	200
Transportation	298.75	300

=TO_TEXT(D2>C2)

Result: "TRUE"

TO_TEXT converts the boolean result of the comparison (245 > 200) to the text string "TRUE". This is helpful when incorporating over-budget indicators into text-based reports or labels.

Common errors

Which TO_TEXT error are you seeing?

Error	Why it happens	How to fix it
#REF!	When value references a deleted column, row, or cell range that no longer exists.	Verify the referenced cell or range still exists; use Find & Replace to locate and update stale references.
#N/A	When the value or the cell it references contains an #N/A error, typically from VLOOKUP, INDEX/MATCH, or other lookup functions.	Check the source cell for #N/A errors; use IFERROR or IFNA to handle missing values gracefully before passing to TO_TEXT.
#CALC!	When value references a cell involved in a circular calculation, creating a loop where formulas depend on each other.	Review formula dependencies; break the circular reference by reordering calculations or using helper columns to separate logic.

Tips and when to use something else

TO_TEXT is best for ensuring consistent text formatting across mixed data types; if you need to format numbers with specific decimal places or currency symbols, use TO_DOLLARS or TO_PERCENT instead.
The conversion is purely format-based—TO_TEXT does not alter the underlying value, only how it's represented in calculations and displays.
Use TO_TEXT when building concatenated strings or labels that combine text and numbers, such as creating budget reports with formatted output.
For complex type conversions, consider combining TO_TEXT with other type functions like TO_DATE or TO_PURE_NUMBER to ensure consistent data types across your sheet.

Related functions

TO_DATETO_DATE converts text or serial numbers into a date value, enabling date calculations and consistent formatting across your spreadsheet.TO_DOLLARSConverts a numeric value to a text string formatted as currency with a dollar sign, commas, and two decimal places for display.TO_PURE_NUMBERConverts a value to its pure numeric form, removing formatting like currency, percentage, or text labels to expose the underlying number.SPLITSPLIT breaks a text string into an array of substrings by dividing on a specified delimiter or by individual characters.JOINConcatenates multiple text values or array elements into a single string, separated by a delimiter you specify.

Frequently asked questions

How is TO_TEXT different from formatting a cell as text?: TO_TEXT converts the value itself to text type, while cell formatting only changes how the value appears visually. TO_TEXT ensures the actual data is text, which affects sorting, filtering, and formulas downstream.
Does TO_TEXT remove decimal places or formatting?: No, TO_TEXT preserves the exact value as-is and simply converts it to text format. A numeric 385.50 becomes the text "385.50", maintaining all precision and decimal points.
Can I use TO_TEXT on cells that are already text?: Yes, TO_TEXT on text cells returns the same text unchanged. This is useful for standardizing mixed-type data or ensuring consistency when combining data from multiple sources.
When should I use TO_TEXT instead of just typing the value as a string?: Use TO_TEXT when converting dynamic values (cell references, formula results, or lookup outcomes) to text, especially in reports where you need the result to adapt as source data changes.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17