Microsoft Office Tutorials and References
In Depth Information
The Custom Option
Figure 5–68. Note that the Type field records the current format in the cell, with the leading zero in place.
Then click in the Type field and simply delete the leading zero. Note the
Sample area shown in Figure 5–69.
Figure 5–69. The zero has been zapped.
Click OK, and all decimal values in the selected cells will lose that zero.
NOTE: The preceding customization won’t change a value such as 3.37; it will only eliminate the
zero on decimals that have no values to the left of the decimal point (e.g., 0.37or 0.98).
Experimenting with the Custom options and observing how the content in the Sample area
changes should prove instructive and useful.