The values in the tables are formatted as numbers instead of text in the Excel export. The logic is applied by default so the user does not need to select formatting behavior.


Note: If a cell contains multiple values, which can be the case when benchmark or ranking is used, the table cannot be formatted as numbers as a cell that for example contains “54% (+12)” cannot be formatted as a number in Excel in a single cell. As soon as a single cell cannot be formatted as number the whole table will be formatted as text to avoid issues such as where cells would have different decimals separators which can happen if some cells are formatted as text (separator chosen in the CrossTab definition) and some as numbers (separator controlled by the regional settings of the user).