Changing codes
 

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
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=401441

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


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=401441

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

cj21 wrote:

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
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=401441

--

Dave Peterson

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


--
mas_detokyo


------------------------------------------------------------------------
mas_detokyo's Profile: http://www.excelforum.com/member.php...o&userid=26712
View this thread: http://www.excelforum.com/showthread...hreadid=401441