excel complete with zero code example
Example: excel complete with 0
=TEXT(A2,"00000000000")
or format only with
CTRL+1 > Number > Custom > Type > 00000000000
=TEXT(A2,"00000000000")
or format only with
CTRL+1 > Number > Custom > Type > 00000000000