Format-leading zeroes and formula

Hi all, I have a spreadsheet with many leading zeroes-I used custom format to do this. Total digits is always 11 but i need to have only first 6 from left. The formula =LEFT(A2,6)is not working because of the leading zeroes...see attached file... Any help will be much appreciated.. Thanks in advance.

There's no file.... assuming you want the 0's

=LEFT(TEXT(A2,"00000000000"),6)