Discussion on:
View:
Show:
Add a column to the right of the incorrectly formatted data, format as %, enter a formula to divide by100, fill down. Copy the column of answers, Paste Special/Values back onto the original column.
Enter 100 in an empty cell and copy it. Select the column values to be converted. Edit/paste special/divide. While still selected, format/cells/percentage. Clear the cell with 100.
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%.
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%.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
