Formatting the Display of Numeric Data

Select the cells in which you want to increase the number of decimals displayed, and click the Increase Decimal button once for each additional decimal place.

Select the cells in which you want to apply commas to your numeric data, and click the Comma Style button.

Select the cells in which you want to apply currency formatting (commas, two decimal places, and a dollar sign $), and click the Currency Style button.

The numeric data formatting options are applied to the selected cells.

INTRODUCTION

You can alter the display of different numbers depending on the type of data the cells contain. This can also make it easier to read. For example, sales numbers can be displayed in a currency format, and scientific data can be displayed with commas and decimal points.

TIP

Percent Style

If you click the Percent Style button on the Formatting toolbar, your numbers are converted to a percentage and displayed with a % symbol.

TIP

Choosing Other Styles

You can choose from numerous other styles to apply to data. To see the other styles, select Format, Cells and click through the many Category options.