changing numbers
 

--------------------------------------------------------------------------------

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

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


Chri

--
cj2
-----------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...fo&userid=2567
View this thread: http://www.excelforum.com/showthread.php?threadid=40145

changing numbers
 

Yes there is. If assume your product code is a text. Select all th
cells and press ctrl + F. In the "look for" box type "0". Then pres
"replace" button. Put "9" in the replace box and press replace all o
replace (which one that suit you).

Best regard

--
hidek
-----------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...fo&userid=1890
View this thread: http://www.excelforum.com/showthread.php?threadid=40145