MID function: extract DIGITS from NUMBERS including LEADING zeros
The MID function in Excel, extracts characters from a text string.
You can also use it to extract digits from a number, but beware: the result will be text and not numbers! You can see this by the left alignment of the numbers in the cells.
In order to convert the result to a number, you can wrap it in the VALUE function.
But if your original number has leading zeroes (the cell is formatted "000"), they will not be recognized as such in TEXT functions! Excel will simply ignore them, and the first digit after the leading zeroes will be considered as the first digit.
This video shows how to use the MID function to extract all digits from a number including leading zeros.