|
|
Changing Text to Numbers Part 2 You can also use the Text Import Wizard to convert text to numbers. To convert the text values by using the wizard, follow these steps: 1. Select the range that contains values you want to convert to numbers. 2. On the Data menu, click Text to Columns. 3. Click Next twice to proceed to step 3 of the wizard. 4. In Column Data Format, click General, and then click Finish. This method converts the text to numbers. You can tell whether you successfully converted the text values by viewing the alignment of the number. If you use the General format and the values are aligned to the right, the values are numbers; text values are aligned to the left.
|