DATEVALUE
Convert text to number, in a locale-independent way.
Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator
Π‘ΠΈΠ½ΡΠ°ΠΊΡΠΈΡ
NUMBERVALUE("Text";decimal_separator;group_separator)
Π’Π΅ΠΊΡΡ: Π΄ΠΎΠΏΡΡΡΠΈΠΌΠΎΠ΅ Π²ΡΡΠ°ΠΆΠ΅Π½ΠΈΠ΅ Π΄Π°ΡΡ, ΠΊΠΎΡΠΎΡΠΎΠ΅ Π΄ΠΎΠ»ΠΆΠ½ΠΎ ΡΠΊΠ°Π·ΡΠ²Π°ΡΡΡΡ Π² ΠΊΠ°Π²ΡΡΠΊΠ°Ρ .
decimal_separator (optional) defines the character used as the decimal separator.
group_separator (optional) defines the character(s) used as the group separator.
ΠΡΠΈΠΌΠ΅Ρ
=NUMBERVALUE("123.456";".";",") yields 123.456