DATEVALUE

Convert text to number, in a locale-independent way.

Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator

tip

This function is available since LibreOffice 4.1.


Syntax

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.

Example

=NUMBERVALUE("123.456";".";",") yields 123.456

Please support us!