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

C

Chirag Dedhia

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"
 
G

Gary''s Student

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.
 
A

aaaron1501

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