CDN
The CDN parameter specifies punctuation used in numeric notation.
Continental Decimal Notation (CDN) is supported for output in TABLE requests. It is not supported in DEFINE or COMPUTE commands.
The syntax is:
SET CDN = option
where:
Is one of the following:
DOTS_COMMA or ON uses
CDN. Sets the decimal separator as a comma and the thousands
separator as a period. For example, the number 3,045,000.76 is represented
as 3.045.000,76. ON should be used for Germany, Denmark, Italy,
Spain, and Brazil.
Note: Numeric parameters that use CDN ON must be separated by a comma followed by a space in calls to functions.
COMMAS_DOT or OFF turns
CDN off. For example, the number 3,045,000.76 is represented as
3,045,000.76. OFF is the default value. OFF should be used for the
USA, Canada, Mexico, and the United Kingdom.
SPACES_COMMA or SPACE sets
the decimal point as a comma, and the thousands separator as a space.
For example, the number 3,045,000.76 is represented as 3 045 000,76.
SPACE should be used for France, Norway, Sweden, and Finland.
SPACES_DOT or SPACEP sets the decimal point as a period and the thousands separator as a space. For example, the number 3,045,000.76 is represented as 3 045 000.76.
QUOTES_COMMA or QUOTE sets
the decimal point as a comma and the thousands separator as an apostrophe.
For example, the number 3,045,000.76 is represented as 3'045'000,76.
QUOTE should be used for Switzerland.
QUOTES_DOT or QUOTEP sets
the decimal point as a period and the thousands separator as an
apostrophe. For example, the number 3,045,000.76 is represented
as 3'045'000.76.
Note: If the display format of a report is Excel 2000 or later, Continental Decimal Notation is controlled by the settings on the computer. That is, numbers in report output are formatted according to the convention of the locale (location) set in regional or browser language options.