Padding with 0

Suppose cell A1 contains numeric value of 1.

You want to customize cell A1 to display 0001:
give the cell a custom format of 0000.

You want to convert it to character value of 0001 on cell B1:
type in cell B1 --> =REPT(0;4-LEN(A1))&A1