Formatting options are sheet level options, which are specific to the worksheet for which they are set. They are also the default formatting option settings for new worksheets in the current workbook or any new workbook. Changes to formatting option settings do not affect existing worksheets or workbooks.
To set options for formatting numbers as described in Table 11, click Options on the Smart View ribbon, and then select Advanced in the left panel.When you are finished, click OK.
To set your selections on this page as default settings, click the arrow in the OK button, and then select Set as Default Options.
Note: | Not all data providers support all the options listed in the table. |
Table 11. 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 Adjust Column width) for data. |
| Adjust Column width | Adjust column widths to fit cell contents automatically. |