Entering numbers followed by a decimal with trailing zeros will not immediately display the zeros. The default format for a number is the category called Number that does not display decimal. Here’s how to display zeros in a cell.
Type any number, followed by a decimal point with any number of zeros after the decimal point. The zeros do not appear.
Click Format > Cells. The Format Cells dialog box appears (See Figure 1). The first tab is labeled Number. In this tab is a Category: box that displays options such as Number, Currency, or Accounting, allowing the Decimal places box to display a chosen number of trailing decimals.
Figure 1
Type the number of decimal places to be displayed, or use the scroll arrows to increase or decrease the number of zeros after the decimal point.
After selecting the number of decimals to be displayed, click the OK button to finish the task.
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-22 06:00:59. Republished by Blog Post Promoter
If you enjoyed this post, make sure you subscribe to my RSS feed!
0 comments ↓
There are no comments yet...Kick things off by filling out the form below.
You must log in to post a comment.