Home >Topics >excel >How to convert decimal point into percentage in excel

How to convert decimal point into percentage in excel

藏色散人
藏色散人Original
2020-02-11 10:43:5414364browse

How to convert decimal point into percentage in excel

How to convert decimal point into percentage in Excel?

Method:

1. Select the area, right-click after selecting it, and click the "Format Cells" button in the drop-down option.

How to convert decimal point into percentage in excel

#2. After clicking, a dialog box as shown in the figure will pop up. At this time, we click the "Number" button on the left.

How to convert decimal point into percentage in excel

#3. After clicking, the picture will appear. At this time, we set the number of decimal places to be retained. After setting, click the "OK" button below.

How to convert decimal point into percentage in excel

#4. After clicking, we can see that the value becomes a decimal again and is no longer a percentage.

5. After clicking the OK button, the picture will appear. At this time, we can see that all the previous decimals have become percentages, indicating that we have set up successfully.

How to convert decimal point into percentage in excel

The above is the detailed content of How to convert decimal point into percentage in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn