Excel: A Question of Balance Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 More
Home ->Format ->Number
Memo to self: Changing the decimals is just formatting, like Bold or Color. The REAL value of the number is displayed in the Formula bar.

 

Format the Decimals

How do you format the number of decimal places you see?

 

Try it: Practice with Decimals

Select: Cell D2.

Enter a new salary: $45,500.68

 

Go to Home -> Number.

Click on Decrease Decimal.

 

 

What Do You See? Watch the numbers in Cell D2 as you click on Decrease or Increase Decimal. Did the number Round Up?

 

 

  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