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