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 14, 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 Save as Default Options.
Note: | Not all data providers support all the options listed in the table. |
Table 14. Number Formatting Options
| Option | Description |
|---|---|
| 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 Cell Styles | Use formatting that is defined in Cell Styles (see Cell Styles) or by the data provider. Overrides any user formatting. |
| Use Excel Formatting | Use Excel rather than Smart View formatting and retain Excel formatting for ad hoc operations. |
| Move Formatting on Operations | Copy parent cell formatting to zoomed in cells and retain this formatting even if the cell location changes after an operation. |
| 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. |