NumToJText

Converts arabic numerals to Japanese text.

Format 

NumToJText ( number ; separator ; characterType )

Parameters 

number - any numeric expression or field containing a number

separator - a number from 0 to 3 representing a separator

characterType - a number from 0 to 3 representing a type

Data type returned 

text

Originated in version 

6.0 or earlier

Description 

If the value for separator and characterType are blank or other than 0 to 3, then 0 is used.

Separator:

  • 0 - no separator
  • 1 - every 3 digits (thousands)
  • 2 - ten thousands(Japanese character for ten thousand) and millions(Japanese character for one million) unit
  • 3 - tens(Japanese character for ten), hundreds(Japanese character for one hundred), thousands(Japanese character for one thousand), ten thousands(Japanese character for ten thousand) and millions(Japanese character for one million) unit

Type:

  • 0 - half-width (hankaku) number
  • 1 - full-width (zenkaku) number
  • 2 - kanji number Japanese kanji character number
  • 3 - traditional kanji number Japanese traditional kanji number

Example 1 

NumToJText(123456789;2;0) returns Arabic numeral 123456789 with half-width hankaku (1-byte) separators between the thousands and ten thousands places, and between the ten millions and hundred millions places.

Example 2 

NumToJText(123456789;3;2) returns Japanese text for the arabic numeral 123456789 using a kanji number separator between the tens, hundreds, thousands, ten thousands, and millions places.

Related topics