By using the excel text formula, you can put 0 in front of any numbers. First Convert the text into numerical String and then adding ZERO in front of numbers. https://www.basicexceltutorial.com/excel-how-to-put-0-in-front-of-numbers/