| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing % to whole numbers | Excel Discussion (Misc queries) | |||
| Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
| Numbers changing | Excel Discussion (Misc queries) | |||
| Changing column of numbers made of formulas to just numbers | Excel Discussion (Misc queries) | |||
| Changing numbers | Excel Discussion (Misc queries) | |||
Linear Mode
