software

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

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.
--
Gary's Studentquot;Chirag Dedhiaquot; wrote:

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

How about using custom format. Format the desired cells as 2####.
Numbers entered in these cells will automatically be prefixed with a
quot;2quot;.Wow Both methods worked.... Thanks ppl! Thanks a million!