Home ->Number

Exam 77-882: Microsoft Excel 2010 Core

2. Creating Cell Data

2.1. Construct cell data: Format the Decimal Places

 

Pick Your Places

3. Try This: Practice with Decimals

Select Column D.

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.10)

 

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.