You are here: Function Reference > Alphabetical Listing > F > FrenchNumText

FrenchNumText

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

Syntax

FrenchNumText (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:

"dollars et"

CentWord

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

"cents"

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).

Example

Please note the system returns only lowercase letters. For instance, if you entered 2000000, the system would return:

deux millions de dollars et 0 cents

(Assume the current field value is 2,000,000.)

Function

Result

Explanation

Return(FrenchNumText ( ))

deux millions de dollars et 0 cents

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

Return(FrenchNumText (123.45,,,2 ))

cent vingt-trois dollars et quarante-cing cents

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

See also

© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.