O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required