Changing codes

C

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
 
M

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
 
Top