NumToJText()

Category: Text

Syntax: NumToJText ( number; separator; characterType )

Parameters:

numberAny numeric expression or field containing a number.

separatorA number from 03 representing a separator.

characterTypeA number from 03 representing a type.

Data type returned: Text (Japanese)

Description:

Converts Roman numbers in the number parameter to Japanese text. If the value for separator and characterType are blank or other than 0 to 3, then 0 is used.

Separator:

0No separator

1Every 3 digits (thousands)

2Ten thousands and millions unit

3Tens , hundreds , thousands , ten thousands , and millions unit

Type:

0Half width (Hankaku) number

1Full width (Zenkaku) number

2Kanji character number

3Traditional-old-style Kanji character number

Examples:

Function

Results

NumToJText(123456789;2;0)

Returns .

NumToJText(123456789;3;2)

Returns .

Категории