Importing from Microsoft Excel®

Zip Code and Taxpayer ID Issues

Introduction  Previous Topic  Next Topic

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.

 

Excel Open Format Cells

 

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).