ONLYOFFICE #VALUE!: Separate Conversion Failure from Missing Text

Scope: ONLYOFFICE Spreadsheet Editor English function documentation checked October 21, 2026. The help pages are not pinned to an installed build. Record whether you use free Desktop Editors or a hosted editor, its version and platform; these examples do not certify older builds, mobile editions or desktop/server parity. No application was executed for this reference. Use a disposable workbook; expected results are documentation-based checks, not native observations.

The same label can describe different problems

ONLYOFFICE documents #VALUE! both when VALUE cannot convert text to a number and when FIND finds no matching substring. Therefore, “convert the cells to numbers” is not a universal repair. First identify which operation failed and what it was supposed to receive.

In an imported workbook, record the original field definition. A product identifier is not necessarily an amount, even if every character is a digit. Keep the original text while testing conversions in a separate column.

Branch 1: text that is not a number

In a disposable sheet put pending in A2. In B2 enter =VALUE(A2). The expected result is #VALUE!: the word does not represent an amount.

For this synthetic test, replace A2 with ="24", a formula returning the text 24. B2 should become the number 24. In C2 enter =B2*3; the independent expected result is 72. Do not replace a real “pending” record with 24: the exercise supplies a known value, whereas real missing information needs verification.

If the original value has regional separators, document which symbol means decimal and which means grouping. ONLYOFFICE’s NUMBERVALUE reference provides explicit separator arguments. With English formula syntax, =NUMBERVALUE("1.234,5",",",".") has an expected numeric result of 1234.5. Multiplying that result by 2 should give 2469. Use the syntax your editor accepts; do not globally replace punctuation in source data.

Branch 2: a text search that has no match

In D2 enter AB-24. In E2 enter =FIND("x",D2). The expected result is #VALUE! because x is absent. If the intended delimiter was the hyphen, change E2 to =FIND("-",D2); its expected position is 3.

FIND is case-sensitive according to the official reference. A failed lowercase search is not repaired by numeric conversion. Decide whether case matters to the identifier and use a matching search rule. Do not change the source identifier’s spelling simply to satisfy a formula.

Keep the cause visible

For conversion, the repair may be correcting an import setting or obtaining the missing amount. For search, it may be correcting the target text or classifying a record with no delimiter. Those outcomes should not share an unexplained zero fallback. Zero can look like a genuine amount, while a zero position can later be misused by a text-extraction formula.

Review valid, missing and malformed records separately. Keep a status column with the original value until the transformation has been checked. See VALUE, NUMBERVALUE, FIND and CSV import typing for the relevant next step.