NUMBERVALUE

Converts the string representation of a number into a locale-independent numeric value.

tip

Aquesta funci贸 茅s disponible des de la versi贸 4.1 del LibreOffice.


The input text may be in a locale-dependent or other bespoke format.

El nombre de sortida rep el format d'un valor de coma flotant v脿lid i es mostra amb el format num猫ric de la cel路la actual.

tip

Refer to the Numbers / Format help page to learn how to change the format of numbers in a cell.


Sintaxi

NUMBERVALUE(Text[; Decimal Separator[; Group Separator]])

Text 茅s una cadena que cont茅 el nombre que s'ha de convertir.

Decimal Separator is a single character that specifies the decimal separator in Text. It can be omitted if Text does not include any decimal or group separators.

Group Separator is a string that specifies the character(s) used as the group separator in Text. It can be omitted if Text does not include any group separators. The Decimal Separator character should not be used in Group Separator.

Exemples

=NUMBERVALUE("1.234.567,89"; ","; ".") returns 1234567.89 (considering en-US locale). The function removes the two group separators and changes the decimal separator from a comma to a full stop.

=NUMBERVALUE("123路4"; "路") returns 123.4 (considering en-US locale). The function changes the decimal separator from a "路" to a full stop. No group separator is used in the supplied number and so the Group Separator argument is omitted.

=NUMBERVALUE("123e12") returns 1.23E+14 (considering en-US locale). No decimal or group separators are used in the supplied number and so the Decimal Separator and Group Separator arguments are omitted.

=NUMBERVALUE("1#!234#!567"; "."; "#!") returns 1234567 (considering en-US locale). Note that in this case the group separator is specified as a two-character string.

Ens cal la vostra ajuda!