How to use Excel NUMBERVALUE Function

Introduction

NUMBERVALUE is a text/string function. This function is used to convert text into number with decimals and separator values in it. For example, =NUMBERVALUE(“2000.990”, “,”, “.”), it gives 2000.99 as the answer. This is a worksheet function and can be entered into the cell in which you wants answer.

Syntax

=NUMBERVALUE(Text, decimal_separator, group_separator)

Arguments

  • Text: It is the text which will be converted into number.
  • Decimal_Separator: It is the character used as decimal separator in the text.
  • Group_Separator: It is the character used as group separator in the text.

Keynotes

  • If any of the arguments is not entered correctly, #VALUE error is displayed.
  • If group separator and decimal separator arguments are interchanged in the formula, #VALUE error is displayed.
  • If Text argument is left blank, 0 is returned.
  • Spaces present in the text are ignored.
  • If more than one character is used in group separator and decimal separator arguments, function uses only the first characters entered.

Examples

In this example, some numbers stored as text are entered in column A and they are converted into number form with decimals and separators in column B by using NUMBERVALUE function.


Leave a Comment