IBM Lotus Symphony


Transforming text-formatted numbers into numbers

When numbers are formatted as text in IBM® Lotus® Symphony™ Spreadsheets, some functions that are related to numbers become unavailable. To change the text-formatted numbers back to real numbers, one way is to reenter the numbers after modifying the cell properties. If you have a column of text-formatted numbers to transform and do not want to reenter the numbers, use the following way.

To transform a column of text-formatted numbers into numbers, do the following steps:
  1. Select the column of cells with text-formatted numbers.
  2. From the main menu, click Data > Text to Columns. The Text to Columns window opens.
  3. In the Fields area, click the column in the preview list, and then select Standard from the Column type list.
  4. Click OK.

Product Feedback | Additional Documentation | Trademarks