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
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:
Open you're My Budget worksheet and change the number of decimal places from two to zero for the numeric values. Doing so shows you how simple Excel makes such formatting.
Worksheets are often cluttered with zeros as a result of calculations or information that hasn't been entered. Formulas frequently display a zero when referenced
The Summary sheet in the My Budget workbook provides a good example of formulas that produce unwanted values of zero. This worksheet shows several columns where data has not been entered. Therefore, the cells with the formulas that total the empty
There are a couple of ways to hide zeros in a worksheet:
Working with Dates
Dates and times are actually numeric values that have been formatted to appear as dates and time. You can change the way Excel displays the date and time if you want.
The Date and Time categories are in the Category list on the Number tab in the Format
The Time format lets you display date and time serial numbers as time values with hours, minutes, seconds, AM, or PM. The default Time format is the
Understanding Date and Time Formats
Excel offers a wide variety of date and time formats, which are listed in Table 46.3.
Table 46.3. Excel's Date and Time Formats