Function note

Text to number reads Arabic, Persian, Devanagari and Thai digits, but not fullwidth digits

FUNC.DATEVALUE · FUNC.SQRT · FUNC.VALUE

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 routeInputsExcelCorrect valueRecorded in
=VALUE("١")
formula-literal
As typed1
0x3ff0000000000000
—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 typed123
0x405ec00000000000
—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 typed123
0x405ec00000000000
—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 typed100
0x4059000000000000
—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 typed1
0x3ff0000000000000
—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 typed1
0x3ff0000000000000
—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 typed35.12833614050059
0x4041906d51932c26
—Excel 16.0.20527.20088, Windows, bitness and CPU not recorded in this reading file
=DATEVALUE("٢٠٢٤-٠١-٠٢")
formula-literal
As typed45293
0x40e61da000000000
—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

Machine-readable note records