If these are truly numbers just formatted to show the leading zero, do this:
pick an empty cell on the worksheet and enter 11000 into it. Select that
cell and copy it (Edit | Copy or [ctrl]+[C])
select the 10000 cells with the numbers to be altered in them and
Then go to
Edit | Paste Special
and choose the [Subtract] option and click OK

You can quickly choose the 10000 cells by entering their address in the Name
Box - the place just above the A column letter where cell address usually
appears. Lets say your numbers are in column B and go from row 2 to 10001,
just enter
B2:B10001 in the Name Box and that'll select them all and have them ready
for the Paste Special | Subtract operation.

If these are not truly numbers, but are text entries, then enter this
formula in the column right next to the first entry (again, assumes in B,
starting at row 2, so this would go into C2)
=Right(B2,3)

Then move the cursor towards the lower right corner of C2 until it becomes a
thin plus symbol and double-click to fill the formula down to the list of
entries in column B.

That's half the job, or 1/3 of it. Now select all of the cells in C that
have the proper value in them and use Edit | Copy (or [ctrl]+[c]) and then
select the original cells and use Edit | Paste Special with the "Values"
option chosen. That will overwrite the 011402 type entries with the last 3
characters (402) in this case. Now you can go delete column C and all those
formulas.

Hope this helps some.

"Claude" wrote:

Example:
011402
011403
011404

How can I remove 011 from a list of 10,000 prefixes?
If anyone can help out I would really appreate it.