Add and remove zeros in front of numbers

When processing some numeric data, sometimes we need to add 0 or remove 0 in the front, as follows:    

Use a variety of methods such as format, calculation, formula to solve.

1. Format method

In the Style>Text, select the format as a Number, and enter 0 in the input box below. 

Note: The number of 0 means how many digits are complemented.

2. Formula method

Enter FORMAT (Object, "#00000000") in the formula.

1. Format method

In Style>Text, select the format as Number.

2. Formula method

1) FORMAT() formula: FORMAT (Object, "#0")

2) SUM () formula: SUM (Object)

3) AVERAGE() formula: AVERAGE (Object)

4) MAX() formula: MAX (Object)

5) MIN() formula: MIN (Object)

Note: When the data involves grouping, do not use the formula of 2)~5), which may change the size of the value.

3. Calculation method

1) Addition: 'Object of removing 0' + 0 . Such as: =A2+0

2) Subtraction: 'Object of removing 0' - 0 . Such as: =A2-0

3) Multiplication: 'Object of removing 0' * 1 . Such as: =A2*1

4) Division: 'Object of removing 0' / 1 . Such as: =A2/1