If you are looking for software to use, go to Huajun Software Park! software release
Location: front pageTutorial strategyTutorialOther tutorials Excel table...

Introduction to how to quickly align decimal points in data settings in Excel tables

Author: Big Beard Date: 2022-03-01

Excel2019
Excel2019-official version

Office software Storage size: 4.63MB Time: 2022-01-27

Software introduction: Excel2019 official version is a widely used Excel table creation tool. Excel2019 Chinese version has a brand new interface, massive templates...

Download now

Some netizens have started Excel but they don’t know how to set decimal points to quickly align. This section introduces the operation of setting decimal points to quickly align data in Excel tables. Friends who don’t know yet can follow the editor to learn. I hope it will be useful to you. help.

​ ​ 1. Open Excel. Because this is a demonstration, select a blank Excel table.

1.jpg

​ ​ 2. Enter multiple data with decimals in the form. Since this is for demonstration, enter any number of data here.

2.jpg

​​ 3. Select the data you entered, right-click the mouse, and select the "Format Cells" option, and then an option box will pop up.

3.jpg

4. In the pop-up option box, click the first option "Number", and then in the "Classification" option, select the "Numeric" option.

4.jpg

5. In the box on the right, find the "Number of decimal places", and there is an adjustment box behind it, and increase the number inside appropriately. For example 8

5.jpg

​​ 6. In the "Example" above, the preview effect of the number you entered will be displayed. Click OK to display the effect above the example.

6.jpg

Come and learn how to quickly align decimal points in data settings in Excel tables. It will definitely help everyone.

Related articles