pattern(
pattern(
NUMBER
,
PATTERN
)

The pattern( function converts a number into text using a pattern.

Parameters

This function has two parameters:

number – is the number you want to convert to text.

pattern – is text that contains a pattern for formatting the number (see Numeric Patterns).

Description

The pattern( function is very useful when used in a formula in an object on a form. Here is a pattern that will output prices with a dollar sign and with a comma every three digits (for example $4,285.25). If the original number has too many digits after the decimal point, the number will be rounded (not truncated) to fit into the formatted text.

    pattern(4234.5287,"$#,.##")☞ $4,234.53

For more information on the variety of patterns that are possible, see Numeric Patterns.

See Also

- Numeric Patterns -- control how a number is displayed or converted to text.
- str( -- converts a number into text, with no formatting.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, but added engineering notation.