Phone correct Line Up Format.

Hi,

I have phone number database and the problem the number in the sheet are not in proper sequence or prefix, some number 055668878, 009715585879. So what logic I use to pull the number which start from 055668875 and remove the zero in starting and add 971. Same with number starting from 009715585879 so remove the zero only. I want all the phone number should be set in the order like 971556465874. I have attach the test excel sheet.