Hi everyone, im a bit stuck with what seems like a simple enough task. Basically we are going to be importing a list of numbers into a spreadsheet, the numbers however have an extra digit due to the way in which they are scanned. We are looking to use a macro to make the amount of digits in the cells 9 numbers instead of 10.

So if the number was:

1234567890

It would become:

123456789

Any help would be great