Hi, I have a list of numbers about 6 characters in length
listed in a spreadsheet. I would like to delete the first
2 numbers that appear in the cell eg (217000 I want to
delete "21" so that only 7000 appears in the cell). Am I
able to use the Range.delete method to do this in VBA or
is there another way I can do this? After this is done I
can then easily filter that list. Please advise the
easiest way to do this.

For Each Cell In Selection
x = Cell.Text
Cell.Value = CDbl(Mid$(x, 3))
Next Cell



On Mon, 27 Sep 2004 21:51:11 -0700, "Touk" wrote:

Hi, I have a list of numbers about 6 characters in length
listed in a spreadsheet. I would like to delete the first
2 numbers that appear in the cell eg (217000 I want to
delete "21" so that only 7000 appears in the cell). Am I
able to use the Range.delete method to do this in VBA or
is there another way I can do this? After this is done I
can then easily filter that list. Please advise the
easiest way to do this.