Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Number to Words Converter (Spanish)
This formula convert numbers in the range 0 - 999,999,999 to all-caps Spanish text. It does not work with: 1) Decimal numbers; 2) Negative numbers; and 3) Numbers with more than 9 digits. Feel free to use it and improve it.

List("",
Case(Mod(Floor([Quantity] / 100000000), 10),
0, null,

1, If(Mod(Floor([Quantity] / 1000000), 100) = 0, "CIEN", "CIENTO"),

2, "DOSCIENTOS", 3, "TRESCIENTOS", 4, "CUATROCIENTOS",
5, "QUINIENTOS", 6, "SEISCIENTOS", 7, "SETECIENTOS", 8, "OCHOCIENTOS", 9, "NOVECIENTOS")
& " ",

Case(Mod(Floor([Quantity] / 10000000), 10),
0, null, 1, null, 2, null, 3, "TREINTA", 4, "CUARENTA",
5, "CINCUENTA", 6, "SESENTA", 7, "SETENTA", 8, "OCHENTA", 9,"NOVENTA")
& "",

If(Mod(Floor([Quantity] / 10000000), 10)>2 and Mod([Quantity], 10000000)<>0," Y "),

If(Mod(Floor([Quantity] / 10000000), 10) = 2,
Case(Mod(Floor([Quantity] / 1000000), 10), 0, "VEINTE", 1, "VEINTIÚN", 2, "VEINTIDÓS", 3, "VEINTITRÉS", 4, "VEINTICUATRO",
5, "VEINTICINCO", 6, "VEINTISÉIS", 7, "VEINTISIETE", 8, "VEINTIOCHO", 9, "VEINTINUEVE"),

If(Mod(Floor([Quantity] / 10000000), 10) = 1,
Case(Mod(Floor([Quantity] / 1000000), 10), 0, "DIEZ", 1, "ONCE", 2, "DOCE", 3, "TRECE", 4, "CATORCE",
5, "QUINCE", 6, "DIECISÉIS", 7, "DIECISIETE", 8, "DIECIOCHO", 9, "DIECINUEVE"),

Case(Mod(Floor([Quantity] / 1000000), 10),
0, null, 1, "UN", 2, "DOS", 3, "TRES", 4, "CUATRO",
5, "CINCO", 6, "SEIS", 7, "SIETE", 8, "OCHO", 9, "NUEVE"))),

If([Quantity]>999999,If([Quantity]>1999999," MILLONES "," MILLÓN ")),

Case(Mod(Floor([Quantity] / 100000), 10),
0, null,

1, If(Mod(Floor([Quantity] / 1000), 100) = 0, "CIEN", "CIENTO"),

2, "DOSCIENTOS", 3, "TRESCIENTOS", 4, "CUATROCIENTOS",
5, "QUINIENTOS", 6, "SEISCIENTOS", 7, "SETECIENTOS", 8, "OCHOCIENTOS", 9, "NOVECIENTOS")
& " ",

Case(Mod(Floor([Quantity] / 10000), 10),
0, null, 1, null, 2, null, 3, "TREINTA", 4, "CUARENTA",
5, "CINCUENTA", 6, "SESENTA", 7, "SETENTA", 8, "OCHENTA", 9,"NOVENTA")
& "",

If(Mod(Floor([Quantity] / 10000), 10)>2 and Mod([Quantity], 10000)<>0," Y "),

If(Mod(Floor([Quantity] / 10000), 10) = 2,
Case(Mod(Floor([Quantity] / 1000), 10), 0, "VEINTE", 1, "VEINTIÚN", 2, "VEINTIDÓS", 3, "VEINTITRÉS", 4, "VEINTICUATRO",
5, "VEINTICINCO", 6, "VEINTISÉIS", 7, "VEINTISIETE", 8, "VEINTIOCHO", 9, "VEINTINUEVE"),

If(Mod(Floor([Quantity] / 10000), 10) = 1,
Case(Mod(Floor([Quantity] / 1000), 10), 0, "DIEZ", 1, "ONCE", 2, "DOCE", 3, "TRECE", 4, "CATORCE",
5, "QUINCE", 6, "DIECISÉIS", 7, "DIECISIETE", 8, "DIECIOCHO", 9, "DIECINUEVE"),

Case(Mod(Floor([Quantity] / 1000), 10),
0, null,

1, If(Mod(Floor([Quantity] / 10000), 100) = 0, "", "UN"),

2, "DOS", 3, "TRES", 4, "CUATRO",
5, "CINCO", 6, "SEIS", 7, "SIETE", 8, "OCHO", 9, "NUEVE"))),

If(Mod(Floor([Quantity] / 1000),1000) <> 0, " MIL "),

Case(Mod(Floor([Quantity] / 100), 10),
0, null,

1, If(Mod([Quantity], 100) = 0, "CIEN", "CIENTO"),

2, "DOSCIENTOS", 3, "TRESCIENTOS", 4, "CUATROCIENTOS",
5, "QUINIENTOS", 6, "SEISCIENTOS", 7, "SETECIENTOS", 8, "OCHOCIENTOS", 9, "NOVECIENTOS")
& " ",

Case(Mod(Floor([Quantity] / 10), 10),
0, null, 1, null, 2, null, 3, "TREINTA", 4, "CUARENTA",
5, "CINCUENTA", 6, "SESENTA", 7, "SETENTA", 8, "OCHENTA", 9,"NOVENTA")
& "",

If(Mod(Floor([Quantity] / 10), 10)>2 and Mod([Quantity], 10)<>0," Y "),

If(Mod(Floor([Quantity] / 10), 10) = 2,
Case(Mod([Quantity], 10), 0, "VEINTE", 1, "VEINTIÚN", 2, "VEINTIDÓS", 3, "VEINTITRÉS", 4, "VEINTICUATRO",
5, "VEINTICINCO", 6, "VEINTISÉIS", 7, "VEINTISIETE", 8, "VEINTIOCHO", 9, "VEINTINUEVE"),

If(Mod(Floor([Quantity] / 10), 10) = 1,
Case(Mod([Quantity], 10), 0, "DIEZ", 1, "ONCE", 2, "DOCE", 3, "TRECE", 4, "CATORCE",
5, "QUINCE", 6, "DIECISÉIS", 7, "DIECISIETE", 8, "DIECIOCHO", 9, "DIECINUEVE"),

Case(Mod([Quantity], 10),
0, null, 1, "UN", 2, "DOS", 3, "TRES", 4, "CUATRO",
5, "CINCO", 6, "SEIS", 7, "SIETE", 8, "OCHO", 9, "NUEVE"))),

If([Quantity] = 0, "CERO", If(Mod([Quantity], 1000000) = 0, "DE ")),

If([Quantity] = 1, " PESO", " PESOS"))
ID
1057
Category
Setup
Author

Jorge Solá
Date Created
11/17/2016 9:56:31 AM
Date Updated
1/25/2017 11:08:41 AM
Comments
Patricio Bustos 1/22/2017 9:41:50 AM
Tks!
Jorge Solá 1/25/2017 11:08:41 AM
I fixed a couple of glitches in the above formula. Please use the following one instead:

List("",
Case(Mod(Floor([Quantity] / 100000000), 10),
0, null,

1, If(Mod(Floor([Quantity] / 1000000), 100) = 0, "CIEN", "CIENTO"),

2, "DOSCIENTOS", 3, "TRESCIENTOS", 4, "CUATROCIENTOS",
5, "QUINIENTOS", 6, "SEISCIENTOS", 7, "SETECIENTOS", 8, "OCHOCIENTOS", 9, "NOVECIENTOS")
& " ",

Case(Mod(Floor([Quantity] / 10000000), 10),
0, null, 1, null, 2, null, 3, "TREINTA", 4, "CUARENTA",
5, "CINCUENTA", 6, "SESENTA", 7, "SETENTA", 8, "OCHENTA", 9,"NOVENTA")
& "",

If(Mod(Floor([Quantity] / 10000000), 10)>2 and Mod(Floor([Quantity]/1000000),10)<>0," Y "),

If(Mod(Floor([Quantity] / 10000000), 10) = 2,
Case(Mod(Floor([Quantity] / 1000000), 10), 0, "VEINTE", 1, "VEINTIÚN", 2, "VEINTIDÓS", 3, "VEINTITRÉS", 4, "VEINTICUATRO",
5, "VEINTICINCO", 6, "VEINTISÉIS", 7, "VEINTISIETE", 8, "VEINTIOCHO", 9, "VEINTINUEVE"),

If(Mod(Floor([Quantity] / 10000000), 10) = 1,
Case(Mod(Floor([Quantity] / 1000000), 10), 0, "DIEZ", 1, "ONCE", 2, "DOCE", 3, "TRECE", 4, "CATORCE",
5, "QUINCE", 6, "DIECISÉIS", 7, "DIECISIETE", 8, "DIECIOCHO", 9, "DIECINUEVE"),

Case(Mod(Floor([Quantity] / 1000000), 10),
0, null, 1, "UN", 2, "DOS", 3, "TRES", 4, "CUATRO",
5, "CINCO", 6, "SEIS", 7, "SIETE", 8, "OCHO", 9, "NUEVE"))),

If([Quantity]>999999,If([Quantity]>1999999," MILLONES "," MILLÓN ")),

Case(Mod(Floor([Quantity] / 100000), 10),
0, null,

1, If(Mod(Floor([Quantity] / 1000), 100) = 0, "CIEN", "CIENTO"),

2, "DOSCIENTOS", 3, "TRESCIENTOS", 4, "CUATROCIENTOS",
5, "QUINIENTOS", 6, "SEISCIENTOS", 7, "SETECIENTOS", 8, "OCHOCIENTOS", 9, "NOVECIENTOS")
& " ",

Case(Mod(Floor([Quantity] / 10000), 10),
0, null, 1, null, 2, null, 3, "TREINTA", 4, "CUARENTA",
5, "CINCUENTA", 6, "SESENTA", 7, "SETENTA", 8, "OCHENTA", 9,"NOVENTA")
& "",

If(Mod(Floor([Quantity] / 10000), 10)>2 and Mod(Floor([Quantity]/ 1000),10)<>0," Y "),

If(Mod(Floor([Quantity] / 10000), 10) = 2,
Case(Mod(Floor([Quantity] / 1000), 10), 0, "VEINTE", 1, "VEINTIÚN", 2, "VEINTIDÓS", 3, "VEINTITRÉS", 4, "VEINTICUATRO",
5, "VEINTICINCO", 6, "VEINTISÉIS", 7, "VEINTISIETE", 8, "VEINTIOCHO", 9, "VEINTINUEVE"),

If(Mod(Floor([Quantity] / 10000), 10) = 1,
Case(Mod(Floor([Quantity] / 1000), 10), 0, "DIEZ", 1, "ONCE", 2, "DOCE", 3, "TRECE", 4, "CATORCE",
5, "QUINCE", 6, "DIECISÉIS", 7, "DIECISIETE", 8, "DIECIOCHO", 9, "DIECINUEVE"),

Case(Mod(Floor([Quantity] / 1000), 10),
0, null,

1, If(Mod(Floor([Quantity] / 10000), 100) = 0, "", "UN"),

2, "DOS", 3, "TRES", 4, "CUATRO",
5, "CINCO", 6, "SEIS", 7, "SIETE", 8, "OCHO", 9, "NUEVE"))),

If(Mod(Floor([Quantity] / 1000),1000) <> 0, " MIL "),

Case(Mod(Floor([Quantity] / 100), 10),
0, null,

1, If(Mod([Quantity], 100) = 0, "CIEN", "CIENTO"),

2, "DOSCIENTOS", 3, "TRESCIENTOS", 4, "CUATROCIENTOS",
5, "QUINIENTOS", 6, "SEISCIENTOS", 7, "SETECIENTOS", 8, "OCHOCIENTOS", 9, "NOVECIENTOS")
& " ",

Case(Mod(Floor([Quantity] / 10), 10),
0, null, 1, null, 2, null, 3, "TREINTA", 4, "CUARENTA",
5, "CINCUENTA", 6, "SESENTA", 7, "SETENTA", 8, "OCHENTA", 9,"NOVENTA")
& "",

If(Mod(Floor([Quantity] / 10), 10)>2 and Mod([Quantity], 10)<>0," Y "),

If(Mod(Floor([Quantity] / 10), 10) = 2,
Case(Mod([Quantity], 10), 0, "VEINTE", 1, "VEINTIÚN", 2, "VEINTIDÓS", 3, "VEINTITRÉS", 4, "VEINTICUATRO",
5, "VEINTICINCO", 6, "VEINTISÉIS", 7, "VEINTISIETE", 8, "VEINTIOCHO", 9, "VEINTINUEVE"),

If(Mod(Floor([Quantity] / 10), 10) = 1,
Case(Mod([Quantity], 10), 0, "DIEZ", 1, "ONCE", 2, "DOCE", 3, "TRECE", 4, "CATORCE",
5, "QUINCE", 6, "DIECISÉIS", 7, "DIECISIETE", 8, "DIECIOCHO", 9, "DIECINUEVE"),

Case(Mod([Quantity], 10),
0, null, 1, "UN", 2, "DOS", 3, "TRES", 4, "CUATRO",
5, "CINCO", 6, "SEIS", 7, "SIETE", 8, "OCHO", 9, "NUEVE"))),

If([Quantity] = 0, "CERO", If(Mod([Quantity], 1000000) = 0, "DE ")),

If([Quantity] = 1, " PESO", " PESOS"))
Feedback
Back to Search Results