LearnFast.Ninja

Change numbers to percents in Excel 2010

How to change numbers to percentages in Excel. Choose how the values in a cell are displayed as percentage, as number, etc... Add percentage symbol to the numbers and change format. There is nice shortcut for this action.

Step 1: Select cell with numbers.


Step 2: Click the Home tab > click Number Format arrow > click Percentage.


Result:


Shortcut: Press Ctrl + Shift + 5.

Tags

excel

percentages percent