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.
2. Enter multiple data with decimals in the form. Since this is for demonstration, enter any number of data here.
3. Select the data you entered, right-click the mouse, and select the "Format Cells" option, and then an option box will pop up.
4. In the pop-up option box, click the first option "Number", and then in the "Category" option, select the "Value" option.
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
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.
Come and learn how to quickly align decimal points in data settings in Excel tables. It will definitely help everyone.
