How Insert Zero Along With Phone Number In Excel Sheet.

[drmadhu 87]

I am back up my all contact in csv format in excel sheet.

In number feild zero is missing in Before all number, when I am manually insert zero in all number excel sheet not supported.

I am transfer my contacts to mobile without zero. problem is that dialing landline number and std call.

So Please guide how to insert zero before phone number in excel sheet,

Edited June 30, 2011 by vijaymalhotra_2007

[abhi.r 95]

Select cell > Right CLick > Format Cells > Category (Number tab): Custom > Type "00000000000" (Eleven Zeroes)

Now when you type 1 it will be displayed as 00000000001

If you type 123 it will be displayed as 00000000123

If you type xxxxxxxxxx it will be displayed as 0xxxxxxxxxx (x is a number)

Hope that helps.

[rbdhoot 11]

insert a ' (apstrophe) before typing a zero.

Edited June 30, 2011 by rbdhoot

[drmadhu 87]

Thanks,

Mean while I am googling and find this below

1. Open the MS Excel Worksheet.

2. Write the number in the cell before you want to add zero.

3. Right click the mouse in the cell, select Format Cells… option. Format Cells window will be displayed.

4. Select the Numbers tab from the window then click Custom option from the leftCategory: section.

5. Select 0 option from the Type section.

6. Type the no. of zeroes as many as your number contains digit. For example, your number is 12345, so now you need to enter five zeros after the selected 0 in the type section i.e. 000000.

7. Click OK. The number of zeros entered by you will be converted to digits and the result would be 012345.

[I_C_U 10]

There are multiple ways though.

If you want to quickly add a '0', use '(apostrophe) as mentioned earlier.

[abhi.r 95]

'(apostrophe)

It changes the cell format to TEXT.

Numbers are read as TEXT, and u cannot add/multiply.. etc..

but I guess you dont need any mathematical calculations. So go ahead with '(apostrophe)

[Genius 817]

I am back up my all contact in csv format in excel sheet.

In number feild zero is missing in Before all number, when I am manually insert zero in all number excel sheet not supported.

I am transfer my contacts to mobile without zero. problem is that dialing landline number and std call.

So Please guide how to insert zero before phone number in excel sheet,

if you want i can do it for you in your address book send me CSV i shall revert back with all zeros - i have a software for doing it in outlook. genius@tclonline.in

[supernova 47]

TRY CONCATENATE function in excel .

[drmadhu 87]

Thanks every one problem is solved.