What is NUMBERVALUE called in Spanish?

In Spanish Excel it is VALOR.NUMERO. The formula =NUMBERVALUE(C2,",",".") is written =VALOR.NUMERO(C2;",";".") (or with commas in Mexico).

Why does NUMBERVALUE use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel NUMBERVALUE function

Turns text into a number, stating which character is the decimal and which the thousands separator. In Spanish Excel it is called VALOR.NUMERO.

Syntax

English Excel

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

Spanish Excel (Mexico)

=VALOR.NUMERO(texto, [separador_decimal], [separador_grupo])

Spanish Excel (Spain, Latin America)

=VALOR.NUMERO(texto; [separador_decimal]; [separador_grupo])

Argument	What it is
text	The number stored as text.
decimal_separatoroptional	The character that separates decimals in that text.
group_separatoroptional	The thousands character in that text.

Example

Data from another system carries invisible characters that TRIM does not remove; CLEAN deletes them. Amounts with dot thousands and comma decimals ("1.234,50") arrive as text: NUMBERVALUE(text, decimal, group) turns them into numbers whatever the regional settings.

=NUMBERVALUE(C2,",",".")

Common mistake

Unlike VALUE, it does not depend on the computer’s regional settings: "1.234,50" with "," and "." gives 1234.5 in any Excel.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice NUMBERVALUE

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/218

My Excel is inExcel functions in English and Spanish

Cleaning imported data: CLEAN and NUMBERVALUE

Example=TRIM(CLEAN(A2))LIMPIAR = CLEAN VALOR.NUMERO = NUMBERVALUE

Step 1/2

In B2, clean each name: no invisible characters and no extra spaces.

	A	B	C	D
1	Imported name	Clean name	Amount (text)	Amount
2	Ana López		1.234,50
3	Luis Pérez		980,00
4	Marta Díaz		12.500,75
5	Jorge Ruiz		3.040,10
6	Sofía Castro		15,90
7

Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.

Frequently asked questions

What is NUMBERVALUE called in Spanish?: In Spanish Excel it is VALOR.NUMERO. The formula =NUMBERVALUE(C2,",",".") is written =VALOR.NUMERO(C2;",";".") (or with commas in Mexico).
Why does NUMBERVALUE use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common NUMBERVALUE mistake?: Unlike VALUE, it does not depend on the computer’s regional settings: "1.234,50" with "," and "." gives 1234.5 in any Excel.