To set options for formatting numbers as described in Table 10, click Options on the Smart View ribbon, and then select Advanced in the left panel.
Table 10. Number Formatting Options
| Option | Purpose |
|---|---|
| Use Thousands Separator | Use a comma or other thousands separator in numerical data. Do not use # or $ as the thousands separator in Excel International Options. |
| Use Excel Formatting | Use Excel rather than Smart View formatting and retain Excel formatting for all ad hoc operations except for pivoting. |
| Retain Numeric Formatting | When you drill down in dimensions, use the scale selected from Scale and/or number of decimal places from Decimal Places under Retain Numeric Formatting for data. |