The Data | Data | Text to Number command allows you to change selected alphanumeric numbers in a data table back to numbers. For instance, the text 00032 can be changed to 32. In addition, the cell justification changes from left (indicating text) to right (indicating numbers).
To change text-format alphanumeric numbers to number format:
Highlight the data table containing the text to change.
Click the Data | Data | Text to Number command.
The selected cell contents change to numbers, and their justification changes from left to right.
See Also