Tuesday, February 27, 2007

Entering percentages

How to enter percentages in Excel?
When I format cells as percentages, the exact percentages don't show up. They get multiplied by 100.

To convert a number into percentage,
RIGHT CLICK->FORMAT CELLS->NUMBER->PERCENTAGE and CLICK OK.
You can also specify the number of decimal places to follow percentage.

Tip:

It is always advised to format cells as percentage before you enter values. This is because if you enter your values and format it to percentage, they get multiplied 100 since cent percentage is equal to 100. For example, if you enter the number 4 and format cells as percentage, you get the value 400%. But if you format the cells as percentage and enter 4, you get the value 4%.You can also enter decimal values if you format the cells prior to entering values.

No comments: