I need to convert 1, 11, 111, and 1111 to 0001, 0011, 0111, and 1111, and then append some text to the resultant. I know how to format the cells as custom 4 digits, but this does not allow me to use them in a formula and append text.
Excel – Make number a given number of digits using Excel
microsoft excel
Related Solutions
Format it as number with 11 digits:
Alternatively, you can also provide a custom format, such as #,##0.00000000000
Best Answer
To add leading zeros, use the TEXT function:
To append text, use &