ISNONTEXT Function (Gnumeric)

Use ISNONTEXT to flag values that are not stored as text, such as numbers or logical values in a column intended for identifiers. Gnumeric’s official Information manual defines the function as a one-argument test of whether a value is not text; it does not trim strings or convert numbers to text. R1

=ISNONTEXT(value)

value (required) is a cell value, reference or expression. The documented predicate returns TRUE when the evaluated value is not text, FALSE when it is text. No additional arguments or defaults are documented. Text entered with quotation marks differs from an unquoted numeric literal. R1

Native-validation limits: All outputs are source/documentation-based expectations, not native Gnumeric observations.

Version and platform: The official Gnumeric manual is labelled 1.12 and documents this Information-category function. The project announced Gnumeric 1.12.62 in the current 1.12 series. The official public catalogue lists this function as Complete with Basic project testing, which is not a claim that any examples in this guide were executed. Core Information functions are documented in Gnumeric; actual availability still depends on the reader’s installed version and environment. The introduction date in an earlier minor release was not established. R1R6

Formula notation / locales: Use a leading = in a cell; the examples use the manual’s English function names. This function requires exactly one argument and has no optional parameters or documented defaults, so there is no argument-separator ambiguity in its own syntax. In nested expressions the official formula documentation illustrates commas; operating-system locale can affect language and numeric formats, so check your Gnumeric installation if a pasted multi-argument formula is parsed differently. R4

1. Open a new worksheet. Add descriptions in A2:A6 if helpful.
2. Enter the exact =... formulas in B2:B6 shown below; do not type the displayed error labels manually.
3. Enter the matching test formulas in C2:C6. The results below are expected, not native observed.
4. Compare your installed Gnumeric results and record the local version, locale, and mismatches before adoption.

On a narrow screen, scroll sideways to view this complete example.

Reading the results: Blank-cell and error-value ISNONTEXT behaviour is explicitly held for native testing; do not elevate expected classifications to observed outcomes. The classification follows the official definitions R1 and Gnumeric’s documented error/cell types R4.

Audit imported product IDs without silently converting them

Suppose column B should contain text product codes. Put this in C2 and fill down:

=IF(ISNONTEXT(B2),"Review: not stored as text","Text value")

The five example rows are expected to show: C2 = Text value, C3 = Review: not stored as text, C4 = Text value, C5 = Review: not stored as text, C6 = Text value. This catches accidental numeric or Boolean types even when the displayed digits look like a code. It does not prove an ID is nonempty or follows a required pattern. R1R4

Handle missing values separately

Leave B7 completely empty (do not type spaces or =""). Enter this in C7:

=IF(ISBLANK(B7),"Missing",IF(ISNONTEXT(B7),"Wrong type","Text value"))

Expected: Missing, because Gnumeric’s ISBLANK documentation differentiates a genuinely empty cell from an empty string. Checking ISBLANK first avoids relying on undocumented details of ISNONTEXT for blank references. Test this blank-cell case natively before using it for automated import acceptance. R1

Compare text detection functions

=ISTEXT("42") is expected to return TRUE; =ISNONTEXT("42") is expected to return FALSE. ISNUMBER(42) is expected to return TRUE whereas ISNONTEXT(42) also returns TRUE. Therefore ISNONTEXT does not mean ISNUMBER: Booleans and other nontext classes can also satisfy it. R1

• Why is numeric 42 TRUE but quoted "42" FALSE? Formatting a number to look like text is not the same as storing text. Enter the sample values using their formulas so the underlying types are clear. R1
• Why is ="" FALSE? That expression returns an empty text string, not a genuinely empty unused cell. Use ISBLANK for emptiness rather than assuming an empty-looking display is a blank cell. R1
• What about a truly empty referenced cell? The broad definition suggests that a blank is not text, but this precise boundary was not directly stated for ISNONTEXT in the manual and was not natively tested here; use ISBLANK explicitly and record your observed result. R1
• What if the source cell contains an error? The official brief description does not state error coercion/propagation details for ISNONTEXT. Add a native test before relying on a TRUE/FALSE outcome; do not classify errors as accepted IDs. R1
• Why does a pasted column show mixed results? CSV imports and the current locale can cause numeric-looking strings to be parsed as numbers. Inspect cell types and import settings rather than replacing the audit with TEXT formatting. R4

Gnumeric’s official Information manual labels ISNONTEXT Excel compatible. It is a documented functional classification, not a cross-version regression test. Beware importing CSVs or changing locales: data-type inference can alter the input type before this function evaluates it. R1 The public catalogue reports a Complete implementation and Basic project testing for this canonical spelling; this is metadata about the project, not a site-specific validation record. R3

ISTEXT · ISNUMBER · ISBLANK · ISLOGICAL · IF · TYPE.

The following are official Gnumeric references (accessed 2026-10-12 UTC), not evidence of live testing:

• R1 Information-function manual, Gnumeric 1.12: Official synopsis, argument and behaviour.
• R2 Logic-function manual, Gnumeric 1.12: IF, IFNA and IFERROR selection semantics.
• R3 Gnumeric function catalogue: Implementation/testing classifications.
• R4 Gnumeric formulas and cell types: Formula entry and error values.
• R5 Languages and locales: Operating-system locale configuration.
• R6 Version 1.12.62 announcement: Official release announcement.
• R7 Official source archive: 1.12-series downloads.

Validation: Official manuals and checksum-verified Gnumeric 1.12.62 source were inspected; expected outcomes were logically evaluated. No native Gnumeric execution, screenshots, locale regression or workbook round-trip tests were performed.