PlanMaker T Function: Return Text Without Converting Numbers
Understand T(Value) in SoftMaker PlanMaker 2026 with text-versus-number examples, empty-string checks and Excel compatibility notes.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in SoftMaker PlanMaker 2026. How formula examples are checked
Quick answer: =T("part-42") is expected to return the text part-42; =T(42) returns an empty text string, not the digits “42” and not numeric zero. Both rules are explicitly documented by SoftMaker PlanMaker 2026. If you need formatted numeric text, see TEXT instead.
Verification status: Official documentation checked on 2026-10-11 (PlanMaker 2026 and available 2021 English manuals); example expectations were independently reasoned. No native PlanMaker execution, localized-device testing, Excel import/export trial or genuine application screenshots.
What T actually does
T is a type-preserving text filter: return a value if it is already text; otherwise return the empty text string "". The function does not stringify numbers, dates or logical values. It is useful when you want to display an optional text note without showing an unwanted numeric entry, but not when you want to preserve every entry as a readable label. SoftMaker says the function is retained mainly for compatibility with older spreadsheet applications, since automatic conversions make it less frequently necessary. Official definition and compatibility note.
For contrast, N("42") returns 0 because the input is text, while T("42") returns the text 42. Conversely, N(42) returns numeric 42, whereas T(42) returns "". The numeric behavior is documented separately by SoftMaker N. This is why a value’s visual appearance is not enough to determine its type.
Exact syntax and argument
=T(Value)
| Argument | Required | Meaning | Type / default |
|---|---|---|---|
Value |
Yes | The value or cell reference to inspect. If text, return it unchanged; otherwise return the empty string. | May refer to text, a number or a logical value. No optional argument or default is documented. |
These are the published function name, argument order and return rules; not a statement that all Excel or PlanMaker editions handle every special type identically. The examples use a comma-free one-argument formula, so locale-dependent argument separators do not arise here. PlanMaker’s English manual uses TRUE for the logical value. SoftMaker 2026 T; 2021 T.
Reproduce the worksheet
On a blank worksheet enter the following contents exactly. Format A3 as Text before entering 42, or type an apostrophe before the digits and confirm it is stored as text. The text 42 in A3 is not the numeric 42 in A4.
| Cell | Enter (stored type) | B cell | Formula in B cell | Expected result | Evidence |
|---|---|---|---|---|---|
| A2 | part-42 (text) |
B2 | =T(A2) |
part-42 (text) |
Independently reasoned from documented rule |
| A3 | 42 (text) |
B3 | =T(A3) |
42 (text) |
Same as official literal example |
| A4 | 42 (number) |
B4 | =T(A4) |
"" (empty text) |
Same as official literal example |
| A5 | TRUE (logical) |
B5 | =T(A5) |
"" (empty text) |
Same as official literal example |
| A6 | blue tag (text) |
B6 | =T(A6) |
blue tag (text) |
Independently reasoned |
To remove type ambiguity, you can test the official literal formulas without entering cells first:
=T("Text")
=T("42")
=T(42)
=T(TRUE)
The documentation gives results Text, 42 as text, empty text, and empty text, respectively. SoftMaker 2026 official examples. In the table, the empty-string result may look like a blank cell; it is a formula output, not evidence that the formula disappeared.
More useful situations
Keep optional comments, not numeric flags
Suppose a notes column contains either a textual message (On hold) or a number (1). Put On hold in A9 and numeric 1 in A10. In B9, enter =T(A9); in B10, enter =T(A10). The expected B9 result is On hold, while B10 contains an empty string. This is inferred directly from the official return rule. Avoid using this filter if numeric flags carry information that should not be discarded.
Distinguish text stored as digits from an actual number
For A3 containing the text 42 and A4 containing numeric 42, compare:
=T(A3)
=T(A4)
The expected results are the digit string 42 and "" respectively. If both happen to display as 42 in another column, check whether import or a text-format setting converted one; repeating =T(A3) will not repair accidental coercion.
Compare T and a deliberate numeric formatter
=T(42)
=TEXT(42,"0")
The first is documented to return empty text. The second is expected to return the text 42 using the PlanMaker TEXT(Number,Format) definition and a custom format’s 0 digit code. The TEXT expectation is independently reasoned from the official TEXT reference and format codes; it was not executed in PlanMaker.
Why T can be misleading for blank checks
A formula returning "" looks blank. So an IF test for T(A12)="" cannot by itself distinguish an empty text value from a numeric value rejected by T. If your goal is to identify the underlying data type rather than simply hide non-text, review the ISTEXT function and confirm its handling of actual blank cells in your PlanMaker edition.
Troubleshooting and limitations
| Symptom | Likely cause | What to check |
|---|---|---|
=T(42) produces an apparently blank cell |
This is the documented result, not a defect | Use TEXT(42,"0") to create digits as text instead |
Digits 42 remain in the result |
The input was stored as text, not numeric | Check import type and preceding apostrophes / Text format |
| A logical cell disappears | TRUE and FALSE are non-text | Choose a separate logic-to-label formula if you want visible words |
| You need a number for a sum | T yields a text or empty string, not a numeric conversion | Work with source values; use VALUE / NUMBERVALUE only when appropriate and verified |
| Unexpected behavior with errors, date types or blank references | Not all coercion and error propagation cases are specified on the T reference page | Test in the installed version; do not treat these edge cases as native-confirmed |
No fabricated error outcomes: the official T page does not comprehensively specify the result for error-valued cells or invalid references. Any error propagation claims require native testing; this guide deliberately avoids promising an exact error label for those cases.
Versions, locale and Excel compatibility
The 2026 T page and 2021 T page agree on the signature and four printed example cases. 2024 exact-page availability, mobile apps, FreeOffice editions and non-English localized installations were not verified in this batch. A 2026 English-desktop-family reference does not prove all platforms expose identical behavior.
Microsoft’s Excel T documentation independently describes the same high-level behavior: return text unchanged and return empty text for non-text; it too describes compatibility as the main reason for retaining T. This supports conceptual formula portability for ordinary text/numeric/logical examples, not a claim that every binary workbook, error value, locale, or special type round-trips identically. No Excel file was opened or saved during this research.
Official references and related functions
- SoftMaker PlanMaker 2026 — T — accessed 2026-10-11, syntax, text-only return rule, four examples and compatibility note.
- SoftMaker PlanMaker 2021 — T — accessed 2026-10-11, older official wording/examples; used only for documented continuity.
- SoftMaker PlanMaker 2026 — N — accessed 2026-10-11, contrasting numeric behavior.
- SoftMaker PlanMaker 2026 — TEXT — accessed 2026-10-11, deliberate formatted numeric-to-text conversion.
- SoftMaker PlanMaker 2024 — ISTEXT — related type check; available in official function catalogue; native blank-cell behavior not verified.
- Microsoft Excel — T function — accessed 2026-10-11, cross-product comparison only.
No genuine application screenshot is included; no mock PlanMaker interface is represented as real.