Does anyone know a way to split 12 digit number into separate digits starting from 0 using Excel.

Example :012345678901 is split as 0,1,2,3,4,5,6,...

I've use this formula `=MID($A1,column()-1,1)`

but it is unable to read the 1st digit 0. It keeps appearing as 1,2,3,4,5,... instead of 0,1,2,3,4,5,... and also if there is a number starting with 00.

Is there any formula that its able to read 0 or 00 as the first number followed by the rest?