| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
| VBA Codes | Excel Worksheet Functions | |||
| changing page break in an excel file | New Users to Excel | |||
| Excel doesn't sort zip codes properly | Excel Discussion (Misc queries) | |||
| Set column to only allow certain codes??? | Excel Worksheet Functions | |||
Linear Mode
