View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cj21 cj21 is offline
external usenet poster
 
Posts: 1
Default 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