Microsoft Office Tutorials and References
In Depth Information
Formatting cells containing numbers
Formatting cells containing numbers
Numerical data plays a central role in Excel workbooks;
therefore, it stands to reason that you have lots of options for
choosing how you want your numbers to appear. Two frequently used
formats are the Accounting number style, which displays a cell’s
contents as a monetary value, and Percent, which multiplies a
value by 100 and adds a percent sign to the end. The two
biggest benefits of formatting data as a percent are that you save a
lot of time (and avoid mistakes) by not typing the decimal point
or percent sign yourself and that you can tell the values are
percentages at a glance.
Two other options for formatting your numbers are to
display the values in a cell with commas every third digit and to
increase or decrease the number of digits to the right of the
decimal point. Although two decimal places are sufficient for
most financial data, you might need to track currency exchange
amounts to three or four decimal places.
Display numerical values as currency and
1 Select the cells that you want to format.
2 Click the Home tab.
3 Using the tools in the Number group, follow any of these steps:
a Click the Accounting Number Format button to apply the
currency style with two decimal places. You can choose a currency
symbol other than your default (which is the $ sign in the United
States) by clicking the down arrow at the right edge of the
Accounting Number Format button.
b Click the Percent Style button to add a percent sign with no
decimal places.
c Click the Comma Style button to add a comma format with two
decimal places.
Search JabSto ::

Custom Search