Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you about the Excel table how to convert decimals into percentages. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

The reported data is returned, saying that the decimal in the Excel table should be a percentage, the header is clearly marked%, does not affect the use of it, why is it necessary to be uniform? Fortunately, it is not a highly skilled operation.

Conversion of decimal number to percentage in Excel table by function calculation

1. Select [C1], enter [= TEXT (A1, "#%")] in the cell, and enter enter.

2. Select the remaining decimal cells, right-click, and select "copy" from the pop-up shortcut menu.

3. Select the range of cells you want to paste into, right-click, and click [Formula] under paste options in the pop-up shortcut menu. In this way, all decimals are converted by percentage.

Conversion of decimal number to percentage in Excel table through cell setting

1. Take the decimal in the following document as an example, first select the cell area to which you want to display the decimal, right-click, and click [format cells] in the pop-up shortcut menu.

2. Switch to the number tab in the pop-up dialog box, select [percentage], and set the number of decimal places to [2]. Click [OK] when finished.

3. The decimals selected in the A1 cell are converted to percentages.

The Enterprise Network disk Nuts Cloud reminds you:

Do not change the decimal value at will, lest the result does not correspond to the decimal value. If you need to keep the original data, just select other cells when formatting the cells.

This is how the Excel table shared by the editor converts decimals into percentages. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.