Unsupported IBM Cognos 8 Formatting

About 30% of the formatting functions available in IBM Cognos 8 are not supported in Microsoft Excel. In particular, Excel does not allow changing locale-dependent formatting attributes, such as the following:

Decimal Separator

Exponential Symbol

Group Separator

Monetary Decimal Separator

AM String

Day Name

Day Short Name

Decimal Delimiter Symbol

Month Name

Month Short Name

PM String

In addition, Excel does not support the following:

Format Width

International Currency Symbol

List Separator

Percent Symbol (Excel does not support percent symbols for charts)

Multiplier

Overline Text Format

PerMill Symbol

Plus Sign

Scale (Excel has a different scaling formula than IBM Cognos 8)

Calendar (Excel does not allow changing the calendar)

Era Name

First Day Of Week

Show Era