|
Build Automator Documentation
Number formats |
|
Previous
Top
Next
|
|
|
Numbers
Syntax: @N [currency] [sign] [fill] size [grouping] [places] [sign] [currency] [B]
All numeric and currency formats start with @N or @n
The currency can be a dollar sign ($) or any character(s) enclosed in tildes (~) It can be either at the beginning or end of the format.
The sign can be a dash (-) or parenthesis (()) If dash it can be either before the fill or after the places. If parentheses they must be in both places.
The fill can be a zero (0), underscore (_) or asterisk (*) and specifies leading fill character.
The size is required to specify the total number of characters that the number will display including any grouping and formatting characters.
The grouping is used to separate the numbers in groups of 3. This should be used along with the hyphen to indicate sign. The grouping can be one of 3 characters: Period (.), hyphen (-) or underscore (_) which produces spaces.
The places is used to indicate decimal separator and decimal places. Decimal separator can be either period (.) or grave accent (`) which produces a comma (,) as decimal separator.
The trailing B will produce a Blank string if the variable is empty or zero.
Numeric |
Result |
Comment |
@N9 |
4,550,000 |
Nine digits, group with commas (default) |
@N_9B |
4550000 |
Nine digits, no grouping, leading blanks if zero |
@N09 |
004550000 |
Nine digits, leading zero |
@N*9 |
***45,000 |
Nine digits, asterisk fill, group with commas |
@N9_ |
4 550 000 |
Nine digits, group with spaces |
@N9. |
4.550.000 |
Nine digits, group with periods |
Decimal |
Result |
Comment |
@N9.2 |
4,550.75 |
Two decimal places, period decimal separator |
@N_9.2B |
4550.75 |
Two decimal places, period decimal separator, no grouping, blank if zero |
@N_9`2 |
4550,75 |
Two decimal places, comma decimal separator |
@N9.`2 |
4.550,75 |
Comma decimal separator, group with periods |
@N9_`2 |
4 550,75 |
Comma decimal separator, group with spaces |
Signed |
Result |
Comment |
@N-9.2B |
-2,347.25 |
Leading minus sign, blank if zero |
@N9.2- |
2,347.25- |
Trailing minus sign |
@N(10.2) |
(2,347.25) |
Enclosed in parenthesis when negative
|
Dollar Currentcy |
Result |
Comment |
@N$9.2B |
$2,347.25 |
Leading dollar sign, blank if zero |
@N$10.2- |
$2,347.25- |
Leading dollar sign, trailing minus when negative |
@N$(11.2) |
$(2,347.25) |
Leading dollar sign, in parenthesis when negative |
Other Currentcy |
Result |
Comment |
@N12_`2~ F~ |
1 5430,50 F |
France |
@N~L. ~12` |
L. 1.430.050 |
Italy |
@N~£~12.2 |
£1,240.50 |
Great Britain |
@N~kr~12`2 |
kr1.430,50 |
Norway |
@N~DM~12`2 |
DM1.430,50 |
Germany |
@N12_`2~ mk~ |
1 430,50 mk |
Finland |
@N12`2~ kr~ |
1.430,50 kr |
Sweden |