Formatting a Worksheet
Denise Etheridge · 2010
Formatting makes the data easier to read and helps conform to company, country, or industry standards. Excel provides a variety of options for formatting numbers. As an alternative to using the Ribbon, you can use the Format Cells dialog box to format cells. The Format Cells dialog box specifies how each number is formatted. Use the Number Format field to apply a number format quickly. Click the down arrow in the Number Format field and a menu appears. Click General to apply the General format. The General format is the default format. Numbers appear as they are typed. As an alternative to using the Ribbon, use the Format Cells dialog box to format cells. The Format Cells dialog box specifies how each number is formatted. In the Format Cell dialog box you can use Number Format options to set the number of decimal places.