Tuesday 10 September 2019

Numbervalue function in Excel

Numbervalue is a function that converts a string into a number in a Locale-independent way.


Syntax of the Numbervalue function is

=Numbervalue(Text,[decimal_separator],[group_separator])
Arguments

Text: The string that you want to convert.

Decimal_Separator: It is optional. The character that separates the integer and decimal part from the number.

Group_Separator: It is optional. The character that separates the group from the number.


            

No comments:

Post a Comment