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


History

VersionStatusNotes
10.0UpdatedCarried over from Panorama 6.0, but added engineering notation.