excel add 0 code example

Example 1: excel add 0

=TEXT(A2,"00000000000")

or format only with 
	CTRL+1 > Number > Custom > Type > 00000000000

Example 2: how to add 0 in front of number in excel

change the data type input string