Hi

use a helper column, in a column to the left of your numbers put in
(assuming your numbers start in A1)
=RIGHT(A1,5)
fill down as needed (move mouse over bottom right corner of the cell until
you see a + then double click),
(once you're happy with the result)
select column B and copy it
click on A1 and choose Edit / paste special - values and click OK
now the account numbers will have been replaced with the last 5 digits of
the account numbers and you can delete column B.

Hope this helps
Cheers
JulieD

"Ndubuisi Azuogu" <Ndubuisi wrote in
message ...
How do I delete 100 account numbers from a spreadsheet colume were it only
leaves the last 5 digits of all the accounts with out having to physicaly
delete each account manually