Excel: A Question of Balance Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 More
Home ->Format ->Number

 

Pick Your Places

More Practice with Decimals

Go to Home -> Number.

Click on Format Cells.

Note: this option can be found in the bottom right corner of the Number group. It looks like a small, blue arrow.

 

 

Format the Number

Category: Currency

Decimal Places: 0

Symbol: US Dollars

Negative Numbers: ($1,234)

 

Red ink is bad news in anybody's bookkeeping, but use the negative sign or parentheses in case you need to print in black and white.

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 2. Formatting Data and Content

  2.3. Format cells and cell content: Format the values in a cell with a specified number of decimal places