How Excel sets the decimal alignment

If you want to implement Excel decimal point alignment, you need to set the cell numeric format for that data. After data is lost in the following diagram, the decimal alignment is not aligned by default.

Small knitting casually enter point data on Excel, and then select the cell point "format"--"cell"--numeric value--To customize and then enter???.?? under Type , the decimal alignment is complete.

“?” is a digit placeholder. When the actual number of digits in a cell is less than the number of placeholder digits in a custom cell format, a space is padded on both sides of the decimal point.

When you set the number of placeholder digits, you can follow the number of digits in this column as a reference to see if you can meet your needs.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join