Converting a text column to a numeric column

Sometimes a column will be imported as text when the data really represents numeric data, and it may be desirable to convert these columns to use numeric storage.

To convert an existing text column into a numeric column:

  1. In the Summary view, select the column you wish to convert
  2. Choose Column > Convert to Numeric

Some information may be lost in the conversion process, including relationships to other columns. The converted column will remain numeric when the table is refreshed, even if the underlying source column contains text data.

See also:


Back to Wizard Help