how excel at the phone number before the bulk plus 0?

There are a number of fixed number of data, such as:053282371135, copy it to excel in automatically when the number of pre-0 removed, in addition to the paste before you excel table cell into a text format settings to prevent, what measures can be taken in bulk 0 before the numbers? These data to a time when other people had been removed was 0 after the data, I would not be able to set up.

Property to the cell types of characters.Cell custom format 000000000000 all the numbers in front of all of Canada 0?
Custom cell format for the “” 0 “G / common format”

can also out-assisted
such as in the B2 enter = “0” & A2
here A2 assumed to be in front of the original data 0 not selected in this line, right – set up single-frame format – digital – Custom – Input
“0” G / GM can not form the only way the province point:the selection of all numbers, as routine, then F2, then home, then 0, and then return so …Cycle until all the change has finished out of the figures in the column B.C1, type in:
= 0 & B1
next to the drag ..