Inputting percentages - in decimal or whole number form?

1. How do you make a percentage into a whole number?
2. What is the shortcut to convert a number to a percent in Excel?

How do you make a percentage into a whole number?

To turn a percent into an integer or decimal number, simply divide by 100. That is the same as moving the decimal point two places to the left.

What is the shortcut to convert a number to a percent in Excel?

Ctrl+Shift+5 [%] is the shortcut to apply the Percent format. The Percent format display the percent symbol and no decimal places. Please leave a comment below with tips on how you quickly increase/decrease the number of decimal places.