Click the % (percent) toolbar button on a Whole number
Typing a number and clicking the % toolbar button is the same as multiplying that number by 100 and adding a percent symbol behind it.
Enter the number 10, and then click the % toolbar button on that cell. The number turns into 1000%.
Click the % (percent) toolbar button on a Decimal number
In another cell, type the number .10 (decimal in front of the 10). Click the % toolbar button on that cell. The number quickly turns into 10%, not 1000%.
Keep in mind the results when converting whole and decimal numbers to percent numbers with the % toolbar button .
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 2009-04-11 22:16:00. 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.