How To Add zero before a Number or Digit in MS-Excel

How To Add zero before a Number or Digit in MS-Excel

Steps To Add Zero In MS-Excel before Any Digit or Number

1. Open MS-Excel And Type Number Before Which You want to Add (example 123 in screenshot)
2. Type Formula =Text(123,"0000") in Desired Cell( if You want To Add One Zero Before 123. 

Note: if Number has 3 digit You have to Add Four Zeros in                  Above formula. And If you Want Two Zeros Before 123              Number. Then you Should Add 5 Zeros.

3. Then Press Enter And See Result

 Thanks For Reading This Article. Like And Follow Us


Watch Video



Download Our App For Latest IT Tutorials, Quiz, Jobs, Study Material And Much More