fill column (2000)

[fair dos]

Good Afternoon everybody!

How are we today?

A user has a column of data. In each of these cells, there are different numbers. This particular user would like to add a 1 to the beginning of each cell, w/o affecting the content of each cell. So in other words, the contents in each cell is a phone number. So, now that she wants to add a "1" to the beginning of each cell, she would want's to know if there is a way similar to auto fill, so she doesn't have to do it manually. Is there a way? or would it have to be done manually. Thanks!

[WebGenii]

You'll need to insert an extra column for this solution.
Step 1 - Insert column beside column of phone numbers
Step 2 - Starting at the top, in the new empty column enter the formula <font color=red>"=1&</font color=red><font color=blue>cellreference</font color=blue>". Cell reference is, of course a reference to the first phone number in the column beside it.
Step 3 - autofill the formula down the column
Step 4 - copy the cells with the formula in them
Step 5 - Use Paste Special/<font color=red>Values</font color=red> to replace the formula with the results.
Step 6 - Delete the extra column.

Cheers

[fair dos]

I'll give it a try.. thanks!