Excel NUMBERVALUE function

Summary

The Excel NUMBERVALUE function converts text that appears in a recognized format (like numbers, dates, or times) into a numeric value. It’s particularly useful for converting text to a number in a locale-independent way.
Syntax
				
					=NUMBERVALUE(text, [decimal_separator], [group_separator])
				
			
  • text: The text string that you want to convert into a number
  • decimal_separator: [Optional] The character used for the decimal separator
  • group_separator: [Optional] The character used to separate groups of numbers
Return value
A numeric value derived from the text string.

How to use

NUMBERVALUE is used to convert text strings that represent numbers into actual numeric values. This function is especially useful when dealing with numeric data imported from different locales where the format of numbers (like decimal and thousands separators) might differ from the standard format of your Excel environment.

Examples

Simple NUMBERVALUE
Converting Text to a Number: To convert a basic numeric text to a number:
				
					=NUMBERVALUE("1234.56")
				
			
This converts the text “1234.56” to the numeric value 1234.56.
NUMBERVALUE with Decimal Separator
Handling Different Decimal Separators: Converting text with a specific decimal separator:
				
					=NUMBERVALUE("1234,56", ",")
				
			
Converts the text “1234,56” (where the comma is used as a decimal separator) to 1234.56.
NUMBERVALUE with Group Separator
Converting Text with Group Separators: Converting a number in text format with a group separator:
				
					=NUMBERVALUE("1,234.56", ".", ",")
				
			
This converts “1,234.56” to the numeric value 1234.56.
NUMBERVALUE in Data Import
Normalizing Imported Data: Converting numbers from a text file with unusual formatting:
				
					=NUMBERVALUE(A2, ".", " ")
				
			
If A2 contains “1 234.56”, the formula converts it to 1234.56.
NUMBERVALUE for Locale-Specific Formats
Adapting to Different Locale Number Formats: Converting numbers in text format from a different locale:
				
					=NUMBERVALUE("1.234,56", ",", ".")
				
			
This converts the European-formatted number “1.234,56” to 1234.56.

Additional Notes

  • NUMBERVALUE is essential for data processing from various international sources with different numerical formats.
  • Useful in data cleaning, especially when preparing data for calculations or statistical analysis.
  • When importing data, NUMBERVALUE can help ensure that numeric values are correctly recognized and formatted for use in Excel functions and formulas.

Related Functions

Excel DATEVALUE function

The Excel DATEVALUE function converts text-formatted dates into serial numbers, enabling calculations and sorting with valid dates.

Excel VALUE function

The Excel VALUE function converts a text string that represents a number into a numeric value, crucial for calculations.

Excel TIMEVALUE function

The Excel TIMEVALUE function converts a time in text format to a serial number, enabling time calculations and comparisons.

Content Navigation