Hi there,

I have recently been sent a large spreadsheet with close to ten thousand lines on it. I have been given the job of finding a quick and easy way of amending each line.

Whats needs done:
A cell in every record (line) has a 12 digit number but this needs to be reduce to a 9 digit number . i.e. the last 3 digits of every every number needs to be removed.

Can anyone advise of an easier way than going down the sheet one by one and deleting the last three digits of each number for the next week.

Let me know if this does not make sense to anyone. Any help will be very much appreciated.

Many Thanks peeps!