changing numbers

[cj21]

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

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 doing this?


Chris

[hideki]

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

Best regard.