WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

The NUMBERVALUE Function in Excel

January 18, 2022
3.5K Views

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables and more fulfilling your needs perfectly.

lDescription:

The NUMBERVALUE Function can be used to convert numbers in text format which cannot be recognized into numeric values.

lSyntax:

NUMBERVALUE( text, [decimal_separator], [group_separator] )

lArguments:

text: Required. The text value you want to convert to number.

decimal_separator: Optional. The character used as the decimal separator in the text value.

group_separator: Optional. The character used to group by thousands, millions in the text value.

lExample:

Suppose we have a list of numbers displayed in text format that are imported from other applications as follows. Here are the steps to apply NUMBERVALUE function.

1. Click cell D2 and navigate to the Formulas tab. Then click the Insert Function button, enter NUMBERVALUE in the box, and click OK.

2. In the pop-up box, enter A2 at text, B2 at decimal_separator and C2 at group_separator,and click OK. Then drag the fill handle down to the cell where you'd like to apply the function.

3. Notice that if the decimal separator and group_separator are not specified, the function uses NUMBERVALUE current locale separators.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.