The Data | Data | Number to Text command allows you to change numbers in a data table to alphanumeric text. For instance, the number 32 could be changed to 00032. In addition, the cell justification changes from right (indicating numbers) to left (indicating text).
To change numbers to alphanumeric text:
Highlight the numbers to change in the data table.
Click the Data | Data | Number to Text command. The Number to Text dialog appears.
Set the text format in the Number to Text dialog.
Check the box next to the Integer values will have a fixed number of digits option to have all text numbers contain the same number of digits.
If the Integer values will have a fixed number of digits option is checked, enter the Number of digits desired.
If you have selected a specific number of digits, click the check box next to Add leading zeros (if necessary) to make all numbers have the same number of digits, even if leading zeros are necessary.
Click OK to change the numbers to text. Click Cancel to exit the dialog without making any changes.
See Also