How to automatically add decimal points to Excel data? Tutorial on how to automatically add decimal points to data in Excel

When filling in data in Excel, in order to ensure accuracy, we often need to adjust the decimal point to a few decimal places. However, making adjustments cell by cell is time-consuming and laborious. How to automatically add decimal points to cells in Excel? In response to this problem, PHP editor Xigua has compiled detailed steps to help everyone solve this problem quickly and effectively. This tutorial walks you step-by-step through setting up Excel to automatically add the decimal points you need. Read on to learn how.

　The setting method is as follows:

　1. Double-click to open the software and click "File" in the upper left corner.

<code><p><img src="/static/imghwm/default1.png" data-src="https://img.php.cn/upload/article/000/000/000/171960325884942.png?x-oss-process=image/resize,p_40" class="lazy" alt="How to automatically add decimal points to Excel data? Tutorial on how to automatically add decimal points to data in Excel"></p>
</code>

　 2. Then click "Options" in the lower left corner of the new page.

<code><p><img src="/static/imghwm/default1.png" data-src="https://img.php.cn/upload/article/000/000/000/171960326068459.png?x-oss-process=image/resize,p_40" class="lazy" alt="How to automatically add decimal points to Excel data? Tutorial on how to automatically add decimal points to data in Excel"></p>
</code>

　 3. After entering the new window interface, click the "Advanced" option in the left column.

<code><p><img src="/static/imghwm/default1.png" data-src="https://img.php.cn/upload/article/000/000/000/171960326334761.jpg?x-oss-process=image/resize,p_40" class="lazy" alt="How to automatically add decimal points to Excel data? Tutorial on how to automatically add decimal points to data in Excel"></p>
</code>

　 4. Then find the "Automatically insert decimal point" on the right, check the small box, and enter "2" in the input box below. Finally click "OK" to save.

<code><p><img src="/static/imghwm/default1.png" data-src="https://img.php.cn/upload/article/000/000/000/171960326593237.jpg?x-oss-process=image/resize,p_40" class="lazy" alt="How to automatically add decimal points to Excel data? Tutorial on how to automatically add decimal points to data in Excel"></p>
                        </code>

The above is the detailed content of How to automatically add decimal points to Excel data? Tutorial on how to automatically add decimal points to data in Excel. For more information, please follow other related articles on the PHP Chinese website!