• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 9. Changing the Look of Values > Working with Decimal Places

Working with Decimal Places

All of Excel's number formats use either two or zero decimal places. The exception is General format, which uses as many places as needed for a value. You can establish a fixed number of decimal places or let Excel automatically round numbers for you. The following sections examine both ways to work with decimal places.

Establishing a Fixed Number of Decimal Places

To establish a fixed number of decimal places, use a numeric format other than General format. Two tools on the Formatting toolbar enable you to change the number of decimal places for numbers. The tools are Increase Decimal (its icon contains .0 and .00 with a left arrow) and Decrease Decimal (its icon contains .0 and .00 with a right arrow). Here's how these tools work:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint