The pattern( function converts a number into text using a pattern.
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).
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.
For more information on the variety of patterns that are possible, see Numeric Patterns.
|10.0||Updated||Carried over from Panorama 6.0, but added engineering notation.|