FORMATDECIMAL

The FORMATDECIMAL function converts the input numerical value to it's specified decimal format.

Input

Number of Connections: 1
InputData TypeDescription
Input1Integer,Double,DecimalThe numeric value to convert.

Output

OutputData TypeDescription
Output1StringThe decimal form.

Property

NameProperty TypeDescription
FormatString

Specifies the decimal pattern. Reserved pattern letters are listed below:

SymbolDescription
0digit (If no value found, set to zero)
#digit (If no value found, not set)
.digit delimiter
,group delimiter
Eseparates mantissa and exponent in scientific notation
;separates positive and negative sub patterns
-default negative prefix
%multiply by 100 and show as percentage
Xother arbitrary characters can be placed at the front or end of the decimal
'used to quote reserved pattern letters in the prefix or suffix; for example, "'#'#" formats 123 to "#123"

Topic


Example

PropertyOutput
Input 11234.567Format#1235

PropertyOutput
Input 123Format00000023

PropertyOutput
Input 112345Format#,###12,345