When enter data with percentage, you can enable automatic percent entry. Whenever you type 555, the value in the cell will become 555% (or 5.55 before formatting). To enable automatic percentage entry, please following steps below:
Step 1: Click the "File" Tab from the ribbon;
Step 2: Click "Options" from the left navigation menu;
Step 3: Click "Advanced" from the left navigation menu in the dialog box;
Step 4: Check "Enable automatic percent entry" under the section of "Editing options";
Step 5: Click "OK" at the bottom.
