how to enter 0 in front of number in excel code example
Example 1: excel complete with 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