Grouping separator. In most countries, the grouping separator separates thousands, but in some countries, it separates ten thousands. If you specify a format string with multiple grouping separators, Data Archive uses the interval between the last grouping separator and the end of the integer. For example, you enter

#,####,###

. Data Archive displays the number 12345678 as 12,345,678.

Separator for positive and negative patterns in a format string. To enter a numeric format string that provides formatting for positive and negative values, enter the positive format string, the semicolon character (;), and the negative format string.

For example:

#,##0.00;(#,##0.00)

Or:

0.00;-0.00

If you do not provide a negative format string, Data Archive uses the positive format string preceded with the negative sign.