add zero number in beginning of phone numbers

[msm1365]

Hi everybody,
I have several phone number and I want them to be added to the phone’s contact section. ‌But this numbers not beginning with zero. i want to adding zero to beginning of this numbers. i try it in format cells/numbers/category/number/leading zeroes and Everything was OK. but when i adding this numbers file to mobile contacts, there is no zeroes at beginning of numbers.

again i tried from this way : cells/numbers/category/Text
all thing is Okey and zeroes were displayed in contacts.
in this way i should add zeroes manually and this is very hard and time consuming. how can i do this way autimatic?

[JohnSUN]

The first step - formatting cells with leading zeros - you did it right.

The second step - converting cells to text - can be done easily and quickly using Data-Text to Columns.

[ml9104]

First, convert all your phone numbers to text.

To add a leading zero to all numbers, use the function CONCATENATE in a separate column for all numbers.

CONCATENATE(“0”;A1)

CONCATENATE(“0”;A2)

…

etc.

Copy the results as text to a new column. This now contains your telephone numbers in plain text for you to use in your phone book.

[msm1365]

thank a lot, your answer add a (0) to beginning of numbers!!! for example (0) 9361215784
But i want this format : 09361215784

[JohnSUN]

You didn’t say anything about the desired format in your question. If you need only 11 digits in a row without any separators, then use a simple number format with the right number of leading zeros.

By the way, this is your remark DOESN’T ANSWER YOUR QUESTION - You have in vain placed this text as an answer, not a comment.