Ndubuisi

If the account number is in say A1, then in a spare cell to the right type

=RIGHT(A1,5)

and enter, now copy down the 100 rows and copy this new account number,
select the old account numbers and Editpaste special...Values the new ones
over the top of the old. Now delete the column you used to create the new
numbers

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"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