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