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.