Excel 2007 : how to put 00 prefix to all country calling codes

**everfresh1** · 03-20-2010, 10:26 AM

Hi.

i have below example of some country calling codes.

9379
937504
355
355422
1264772
6721
1268
1268464

i want to put 00 in start of all numbers.
So it will look like below:

009379
00937504
00355
00355422
001264772
006721
001268
001268464

How can i do that please ?

Thanks.

**mrice** · 03-20-2010, 10:41 AM

In excel type the following formula into an adjacent cell (e.g.) B1

="00" & A1

and copy down by double clicking on the fill handle (little square at the bottom right hand corner of the selected cell.

To keep the new value and remove the formula, select the 00 area and copy. Without changing the selection, hit Edit - paste special and select the values option.

**everfresh1** · 03-20-2010, 10:56 AM

Hi.

i have excel 2002

i even do not understand to the method.

if you can tell me step by step.

i can manualy put 00 in start of all numbers. but this is not a good idea.

i want to do in short cut.

Thanks.