How to prefix "2" to every cell in a column

[Guest]

For ex: if the Value in the Cell is "3456" i want to change that to "23456".
Similarly every cell should be prefixed with "2"

 

[Guest]

If all the cells in question contain 4 digit numbers, then:

1 enter 20000 in an un-used cell
2 copy the cell
3 select the cells you want to change
4 edit / paste / special / with the addition button checked

if the cells do not contain 4 digit numbers, then do not use this method.

 

[aaaron1501]

How about using custom format. Format the desired cells as 2####.
Numbers entered in these cells will automatically be prefixed with a
"2".

 

[Chirag Dedhia]

Wow Both methods worked.... Thanks ppl! Thanks a million!