How to automatically add percent signs to numbers in excel

1. Select the cell, right-click, and select [Format Cells];

2. Select [Number] 】Category [Percent] under the column, set the number of decimal places as needed;

3. Enter the data we need and press Enter.

You can see that the original value has not changed.

Recommended tutorial:excel tutorial

The above is the detailed content of How to automatically add percent signs to numbers in excel. For more information, please follow other related articles on the PHP Chinese website!