FN-VALUE-001: Text to number reads Arabic, Persian, Devanagari and Thai digits, but not fullwidth digits
Quirk · measured · recorded 2026-11-04
In the recorded en-ZA settings, converting text to a number accepts Arabic-Indic (U+0660 to U+0669), extended Arabic-Indic (U+06F0 to U+06F9), Devanagari (U+0966 to U+096F) and Thai (U+0E50 to U+0E59) digits. They work alone, in runs, with a decimal point, in the exponent, with a sign or percent, and mixed with ASCII digits or with each other: VALUE("1٢3") is 123, and SQRT of a four-digit string using four scripts is the root of 1234. Fullwidth digits (U+FF10 to U+FF19) give #VALUE! alone or mixed. DATEVALUE reads the four accepted scripts in a date written year-month-day.
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
=VALUE("١")formula-literal | As typed | 10x3ff0000000000000 | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=VALUE("١٢٣")formula-literal | As typed | 1230x405ec00000000000 | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=VALUE("1٢3")formula-literal | As typed | 1230x405ec00000000000 | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=VALUE("١e2")formula-literal | As typed | 1000x4059000000000000 | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=VALUE("१")formula-literal | As typed | 10x3ff0000000000000 | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=VALUE("๑")formula-literal | As typed | 10x3ff0000000000000 | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=VALUE("1")formula-literal | As typed | #VALUE! | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=VALUE("123")formula-literal | As typed | #VALUE! | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=SQRT("۱٢३๔")formula-literal | As typed | 35.128336140500590x4041906d51932c26 | — | Excel 16.0.20527.20088, Windows, bitness and CPU not recorded in this reading file |
=DATEVALUE("٢٠٢٤-٠١-٠٢")formula-literal | As typed | 452930x40e61da000000000 | — | Excel 16.0.20527.20088, Windows, bitness and CPU not recorded in this reading file |
Basis: 66 recorded VALUE readings (all ten digits of each of the five scripts, then composed forms), 10 SQRT and 4 DATEVALUE readings.
Inferred: That other text-to-number routes, such as arithmetic operators, treat digits the same way is inferred from VALUE and SQRT agreeing.
Open: Other digit blocks (Bengali, Tibetan, Khmer and so on) have not been read.
Open: Whether the set depends on the Windows or workbook locale has not been read.
Evidence and capture sources
- DnaCalc · apps/dna-onecalc/tests/acceptance.rs 55697ab4f74bab852fef7bc76b08588c3a5f408e · delivered_fn4_digit_scripts_and_numeric_date_widths recorded answers pinned
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheets qt031 to qt096 66 recorded readings
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/SQRT.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · 10 recorded readings
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/DATEVALUE.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · 6 recorded readings
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet qt042, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet qt081, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet qt084, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet qt088, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet qt062, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet qt072, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet qt032, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/functions-fn4-text-controls.capture.json 2d0eddcac86413014643af81d646581d54ba57bc · sheet qt093, row 20, column 10
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/SQRT.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · fn7-SQRT-digits-6
- DnaCalc · crates/calc-func/tests/captures/fn4_questions/DATEVALUE.reading.json 2d0eddcac86413014643af81d646581d54ba57bc · fn7-DATEVALUE-digits-1