Importing from Microsoft Excel®
Zip Code and Taxpayer ID Issues
As mentioned in the previous topic, Excel has dropped the leading zero in the Zip and Tax ID columns because these columns have been regarded as numeric so leading zeros are insignificant. Excel's Format Cells dialog easily overcomes this obstacle.
Figure 2 - Opening the Format Cells Dialog
There are two ways to open Excel's Format Cells dialog: (a) Right-click on the column to be formatted and select Format Cells from the popup menu. This is illustrated in figure 2 above. (b) Highlight the column to be formatted and select Format Cells from Excel's Format menu.
In either case, the Format Cells dialog is opened (see Figure 3 in the next topic).