Importing from Microsoft Excel®

Using The Format Cells Dialog

Excel's Format Cells dialog facilitates formatting an entire column of cells in your spreadsheet. Instructions for opening this dialog were given in the previous topic. Figure 3 below illustrates how to format the entire Zip column of our sample spreadsheet as a 5 digit Zip Code.

Figure 3 - Excel's Format Cells Dialog

In a similar fashion, the entire Tax ID column could be formatted as a Social Security Number. The next topic shows the original sample spreadsheet after all cells have been formatted appropriately.