Importing from Microsoft Excel®

Using The Format Cells Dialog

Introduction  Previous Topic  Next Topic

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.

 

Excel Format Cells

 

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.