SpanishNumText

This function is a Spanish version of the NumText function. The NumText function provides written numeric equivalents, such as One Hundred and Twenty for 120. The SpanishNumText function serves the same purpose, but its output is in Spanish.

Syntax

SpanishNumText (Number, DollarWord, CentWord, Decimode)

Parameter

Description

Number

Enter a valid amount. The default is the current field value.

DollarWord

Enter the word you want to use instead of dollars. The default is:

"euros"

CentWord

Enter the word you want to use instead of cents. The default is:

"centavos"

Decimode

Choose from these options:

1 - numeric decimal amount
2 - spell decimal amount
3 - suppress zero, numeric decimal amount
4 - suppress zero, spell decimal amount

The default is one (1).

Please note the system returns only lowercase letters.

Example

Function

Result

Explanation

Return(SpanishNumText ( ))

If you entered 2000000, the system would return:

Dos millones euros y 0 centavos

The current field value is returned in a written form using euros and centavos. The zero (0) is displayed in a numeric decimal amount format.

Return(SpanishNumText (123.45,,,2 ))

Cien veintitres euros y cuarenta y cinco centavos

The written equivalent for 123.45 is displayed using Decimode 2 with the decimal spelled out.

See also

© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents