How to get right number format in excel sheet

Question

I have received an excel sheet with a list of customers details. For some reason, the column that contains their number, is of different variations. E.g. some are country code etc. I want all the numbers to be in the following format 07######### (where the # corresponds to different digits). Some numbers are in the format of just '7000000000' and doesn't include the 0 at the front. Is there anyway to convert the already existing numbers to one format of 07#########

Answer 1

If I understood you want the number to appear with 11 digits, padding zeros on the left to have always 11 digits.

You can achieve this with the Custom number formatting in Excel:

Select the Range, Right Click, Format Cells --> Custom, and in the Type box type 00000000000 (11 zeros).