Changing codes

[cj21]

I have a series of product codes that all begin with a zero e.g 10455,
0343, 0325.

I want to change all the zeros to a 9 is there a quick way of doing
this?


Chris

 

[cj21]

the e.g is bad all begin with a zero, not a one

 

[Dave Peterson]

You've got a couple of suggestions to your post in .excel.

 

[mas_detokyo]

If it is always 4 digits, how about adding 9000? I mean, put 900
somewhere in the cell then copy it and paste special with operatio
add.
ma