Reply to Message

When you have percentage values in excel already present as numbers, but you want to convert as percentage then use of the method to go to Format Cells:
1. Excel Version before 2007
Format -> Cells
2. Excel Version 2007 or later
Home -> Format -> Format Cells
3. Keyboard shortcut Control + 1

Under Number tab choose 'Custom' then in 'Type:' type as 0"."00% and then press OK.
Now the numbers, say 10, will be converted to percentage with same number, as 10%.

Note: After choosing this format if you re-enter values then the values will be divided by 100. For example, if a cell has the above said format, when you key in value 100 will be shown as 1%.