Input | Number Pattern | Result | Description |
---|---|---|---|
25 | 0 000 | 25 025 | When the value has more positions in the whole number than specified, the complete value is returned. If the value has fewer positions than indicated in the pattern, 0's are padded to the number. |
25 | # ### | 25 25 | When the value has more positions in the whole number than specified, the complete value is returned. If the value has fewer positions than indicated in the pattern, the extra placeholders in the pattern are ignored. |
56874 | $#,###.00 | $56,874.00 | The whole number is formatted with the currency and separator. No decimals were in the first parameter, so the specified formatting added them. |
56874.879865 | ###,###.## | 56,874.88 | Six digits are to the right of the decimal, but only two places are requested, so the value is rounded. |
56874.87 | 000.000 | 56874.870 | Two digits are to the right of the decimal in the source, but the format expects three and adds a zero. |
100 | 0.00 | 100.00 | When the value has more positions in the whole number than specified, the complete value is returned. No decimals were in the first parameter, so the specified formatting added them. |
100 | $ | $100 | The currency sign prefix is placed before the value. |
5.6874 | E4 | 56874 | The coefficient 4 specifies 10 to the 4th power. The value is multiplied by the exponent to produce the result. |
25 | '#'00 | #25 | The special character prefixed the number and is displayed ahead of the result. |
56874 | $###,###.00'R' | $56,874.00R | The text was added to the value as a suffix. |
.25 | "0%" | 25% | The value is multiplied by 100 to produce the percentage. |