Start Free Course
Example #3 - Calculating Average With NUMBERVALUE Function step 5

NUMBERVALUE Excel

Written by ExcelMojo Editorial Team ExcelMojo Editorial Team ExcelMojo editorial profile and article credentials. Full Bio
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Reviewed for accuracy, clarity, and editorial standards. Full Bio
Updated Apr 27, 2026
Read Time 8 min

What Is NUMBERVALUE Excel Function?

The NUMBERVALUE Excel function is a mathematical tool that allows users to convert text that represents a number into an actual numerical value. This function is particularly useful when dealing with data imported from external sources, where numbers may be stored as text. By utilizing the NUMBERVALUE function, users can eliminate any formatting issues and perform various calculations and analyses accurately. The function takes a text argument and evaluates it for any valid numbers; if it identifies a numeric value within the text, it returns the corresponding numerical output.

In the following example, we will demonstrate how to calculate the date and time value from a given value using the NUMBERVALUE function in Excel. The data is presented in a well-structured table, where Column A represents the value and Column B represents the Result.

Frequently Asked Questions (FAQs)

1. Explain the use of NUMBERVALUE with an example.


Consider the below example.
FAQ. example

To perform this calculation, you need to enter the complete formula =NUMBERVALUE(A2). Once you have entered the formula, press the Enter key. To apply this formula to the subsequent values, drag the cursor to cell B3, as depicted in the image below.

FAQ. example output

2. Are there any limitations or considerations to keep in mind when using the NUMBERVALUE function in Excel?

• Firstly, this function can only convert numbers written in standard numeric formats, such as “123” or “-45.67”. It fails to recognize numbers with non-numeric characters, including currency symbols or thousands of separators.
• Additionally, regional differences might affect the conversion process as some countries utilize decimal commas instead of decimal points.
Another critical point is that NUMBERVALUE cannot handle fractions or percentages directly; one must first remove any non-numeric characters or symbols before conversion.

3. Where is the NUMBERVALUE function in Excel?

One can activate the NUMBERVALUE function in Excel using the following steps:
• Choose the empty cell which will contain the result.
• Go to the “Formulas” tab and click it.
• Select the “Text” group.
• Select “NUMBERVALUE” from the drop-down menu.
• A window called “Function Arguments” appears.
• As the number of arguments, enter the value in the “text,” “decimal_separator,” and “group_separator.”  
• Select OK.

Download Template

📥Download the ready-to-use Excel template to practice this tutorial yourself.

Download Excel Template

This has been a guide to NUMBERVALUE Excel. Here we discuss how to use NUMBERVALUE function in excel with examples and downloadable excel template. You can learn more from the following articles –