T Function in Apple Numbers: Keep Text and Ignore Numeric Cells

T preserves a text value while making a referenced cell that contains a number, date, Boolean, or other nonstring value contribute no text. This is useful when migrating spreadsheets that expect a dedicated text-only extraction operation. The function does not parse a string into a number, format a number as a string, or convert every input to printable text. The distinction matters when data columns mix text identifiers, counts, and missing entries.

In Apple’s words the function exists for compatibility with imported spreadsheet tables. For ordinary formatting, retaining the original cell or choosing a function suited to the desired output can be more transparent. See Apple’s T definition.

=T(cell)

Argument position: 1

Official parameter
cell

Requirement
Required; only argument

Exact documented type
Reference to a single table cell

Meaning
Return the cell’s string; otherwise return an empty string.

Apple says the referenced cell may hold any value or be empty. It documents no optional arguments, fallback value, text-format pattern, or multi-cell/range mode. A full-column selection such as T(A2:A20) is not the documented single-cell contract; apply T one row at a time if you want to check a column. For a literal string such as T("hello"), do not assume the Google Sheets or Excel syntax is accepted in Numbers: Apple’s parameter is specifically a cell reference. This guide deliberately teaches verified reference syntax only.

Reference and locale details

In a Numbers table, A2 means the cell in column A, row 2 of the relevant table. If your spreadsheet has multiple tables, insert references using the formula editor or supply the correct table reference rather than assuming a sheet-only reference is unambiguous. Apple’s cell-reference guide describes the reference system.

T has one argument, so =T(A2) needs no argument separator in any region. In multi-argument formulas used alongside it, Apple’s functions overview says to use semicolons instead of commas when the decimal separator is a comma. Function names may be typed with any capitalization. There is no number-format or date-format setting within T itself.

Create a new Numbers table. Keep A1 as the header Imported value and B1 as Text-only result. Enter the following values into A2:A7, respecting the cell types listed. Enter =T(A2) into B2, then fill the formula down to B7. The outputs shown are documentation-derived expectations, not screen-observed results.

Cell: A2

Enter or set in column A
Blue

Input type
Text

B-column formula
=T(A2)

Expected value returned by T
Blue (text)

Cell: A3

Enter or set in column A
150

Input type
Number, not text

B-column formula
=T(A3)

Expected value returned by T
"" (empty text)

Cell: A4

Enter or set in column A
TRUE

Input type
Boolean, not the literal word

B-column formula
=T(A4)

Expected value returned by T
"" (empty text)

Cell: A5

Enter or set in column A
Leave truly blank

Input type
Empty cell

B-column formula
=T(A5)

Expected value returned by T
"" (empty text)

Cell: A6

Enter or set in column A
007

Input type
Text, preserving zeros

B-column formula
=T(A6)

Expected value returned by T
007 (text)

Cell: A7

Enter or set in column A
150 kg

Input type
Text, including the space

B-column formula
=T(A7)

Expected value returned by T
150 kg (text)

Important input tip: Configure A6 as text before entering 007 if necessary. If Numbers has already converted it to numeric 7, the expected output changes to an empty string. Similarly, typing the letters TRUE as text would not test a Boolean. Compare the type of the underlying cell, not only what the display looks like.

The symbol "" above means a returned zero-length text value. It is shown for explanation; the cell ordinarily appears visually empty. Do not infer that an empty-looking result proves the source was a genuinely empty cell. Apple’s one official example uses text in A1 and an empty B1: T(A1) returns the original text, and T(B1) returns nothing.

Safely isolate a code column

Suppose column A contains supplier identifiers (AB-010, 0031) mixed with accidental numeric counts. Apply =T(A2) to a helper column for a text-only view, then inspect empty results to decide whether a value was blank or simply not text. This is not a substitute for validating imported identifier types; numeric identifiers that were already coerced may have lost leading zeros.

Compare with ISTEXT rather than silently discarding information

The documented =ISTEXT(A2) returns TRUE for text and FALSE otherwise. Use it when you want a Boolean audit flag instead of T’s potentially ambiguous empty result. For rows A2 and A3 in the example above, ISTEXT is expected to return TRUE and FALSE respectively. Apple ISTEXT documentation.

An optional nested length check

For the textual Blue example, =LEN(T(A2)) has the expected value 4, because T returns Blue and LEN counts its four graphemes. For the numeric row, the expected value is 0 because T returns empty text. Apple’s LEN documentation counts graphemes rather than bytes. This nested composition is inferred from two documented operations and has not been executed in Numbers; include it in your own application tests.

• Number is visible but T returns empty: The function checks text type; it does not format numbers. If you need the number itself, keep the numeric cell. If you need a formatted numeric string, choose a documented formatter rather than treating T as a converter.
• An identifier unexpectedly disappears: Check whether Numbers has interpreted a code like 007 as numeric 7. Fix the data type at import or entry time, then validate against original records.
• A blank-looking result is confusing: An empty string, a referenced blank cell, and a nontext cell can all look blank after T. Audit the source with ISTEXT and other suitable checks; do not decide data completeness from T alone.
• A pasted formula errors or has different behaviour: Use a single cell reference, not an entire range or an unverified literal-value parameter. Confirm the actual table name, app version, locale, and type of the referenced cell.
• An input contains an error: Apple’s short T entry does not specify detailed error propagation. Do not claim it will suppress or preserve a formula error without native testing. Report any observed errors and include the Numbers build used.
• A string looks like a date or number: Text that happens to contain digits is still text when stored as a string; T does not verify that those digits form a valid date, price, or quantity.

The broad intent aligns, but syntax and special-case handling must not be assumed identical. For portability from Sheets or Excel, replace unverified T literal expressions with a Numbers reference before testing; for errors, check each app’s documentation and an actual workbook. Sources: Excel T, Google Sheets T, and Numbers T, checked 2026-10-12.

Official further reading: Apple T, Apple ISTEXT, Apple LEN, Apple formula references.

• CHAR — continue with a related Apple Numbers calculation.
• CODE — continue with a related Apple Numbers calculation.
• CLEAN — continue with a related Apple Numbers calculation.
• REPT — continue with a related Apple Numbers calculation.
• FIXED — continue with a related Apple Numbers calculation.

For a software-specific comparison: LibreOffice Calc T. A shared name does not establish identical argument, error or version behaviour.

The linked official function documentation was reviewed on October 12, 2026. Apple’s Formulas and Functions Help 15.4 identifies the documentation edition, not a minimum Numbers release or a guarantee of historical platform parity. Selected worked examples were checked using independent mathematical or text-processing models; results are expected values, not observations from the spreadsheet application. Native Apple Numbers execution was not performed. Undocumented coercion, exact error messages and platform-specific behaviour remain unverified.

View reproducible example inputs and independent check results. This record is not a native spreadsheet test log.