Adding digit in front of number in cell in Microsoft Excel

[Thedevotee]

I have a worksheet containing a column of cells each containing a mobile phone number - the number in the cell is 7 digit , but needs to be 8 digit (commencing with a "0" - which is now missing ) I need to insert a 0 at the front of current string of 7 digits in each cell - I've done this before but have forgot how to do. Can you pls tell me what formula / instruction I must use to get a column with desired result - I need the phone number in correct 8 digit format for a SMS transmission program.

[Erakna]

If the phone numbers are entered as numbers, not text, and you merely want the cell value to appear as 8 digits with leading zeros, you can use the Custom format 00000000. If the phone numbers are text or numbers, and you want want the actual cell value to be 8 digits, use the following to create 8-digit text: =TEXT(A1,"00000000") where A1 contains the original phone number. If you want to replace A1 with the result of the formula (in B1, say), copy B1 and use paste-special-value to overwrite A1.

[Bontu]

I will provide you information on two ways. First on how to add number and second on how to add a text in front of number inside a Cell in Microsoft Excel. The process is quiet simple for this. Right click on the cell and then click on Format > Cells > Number tab and then choose Custom from here. Then type 00000000 and you can see a 0 at the front of existing numbers. In the same way you just need to put text under category in place of custom and use =TEXT(A1,"00000000")
(1234567 would display as 01234567)