Bulk formatting of cells

[singingsister]

Hi everyone,

I have a list of people's telephone numbers which I'm sending to a cellphone provider to process (about 200 numbers) but the cellphone provider has come back saying I need to add 011 to the front of each number for their system to process it.

What's the easiest way of doing this without having to manually add '011 to each cell?

Sarah

 

[Lewiy]

Assuming numbers are in column A, in a new column put
="011"&A1
And copy down

 

[Richard Schollar]

Hi Sarah

Probably easiest to use an adjacent column with the following formula (assuming A col contains the phone numbers):

="011" & A1

and copy this down. Then copy + pastespecial>values from this adjacent column into column A and then delete the adjacent column

 

[Akashwani]

Hi Sarah,

Highlight your range.
Right Click.
Format Cells.
Custom.
Then paste this into the box....
"011" General
Click OK.

Good luck

Ak

 

[singingsister]

Hi Sarah

Probably easiest to use an adjacent column with the following formula (assuming A col contains the phone numbers):

="011" & A1

and copy this down. Then copy + pastespecial>values from this adjacent column into column A and then delete the adjacent column

Hi Richard

Just to say, I can't add any additional columns as it's work I'm doing as part of a massive project and all columns left and right have lots of vlookup formulas in and I'm not allowed to add any columns in.

 

[singingsister]

Hi Sarah,

Highlight your range.
Right Click.
Format Cells.
Custom.
Then paste this into the box....
"011" General
Click OK.

Good luck

Ak

Hi

I did this. Some of the cells it worked for, but for some it shows
001 4.413393E+11.

What does that mean?

 

[singingsister]

Anyone?

 

[Lewiy]

You need to reformat your columns as text after that

 

[Akashwani]

Hi Sarah,

I may be mistaken and Richard can correct me, but I think that means the number in the cell exceeds the maximum number of decimal places.

The numbers need to be text and not real numbers.

Good luck

Ak

 

[singingsister]

Hi Sarah,

I may be mistaken and Richard can correct me, but I think that means the number in the cell exceeds the maximum number of decimal places.

The numbers need to be text and not real numbers.

Good luck

Ak

I'm not sure I understand.