Reference formatting options in a query

Before you can reference the formatting options, you must have inserted them into a location in your worksheet. For more information, see Configuring Global Formatting Options.

The following procedure assumes that you are using a wizard to create the query.

To reference formatting options in a query:

1. In the wizard, select the Select cells to specify format options.

2. Either type in the cell range that contains the formatting option values displayed in your spreadsheet or select the cells. For more information, see Selecting Cells.

   The query results are formatted according to the option settings. Note that the function references the formatting option cells.