Bank Recon - How to convert 8 digit formatted check numbers to 6 digit

The purpose of this is to process the Payroll Bank Reconciliation and reduce time spent in matching and outstanding list to checks cleared. This is a large company so its very time consuming.

I have an excel report that lists all payroll checks cut in a given month. It lists them in 8 digit format (ex. 00265300).
The PDF bank statement, lists the check in 6 digit format, so the example above is listed as "265300". My thinking is to convert the PDF to Excel and import it into the spreadsheet that has the outstanding list in 8 digit format.
So rather than editing out manually, the zeros that preface the remaining 6 digits, is there a way to do this thru formula?

I want to be able to have the imported bank statement of cleared checks, look for each check number in another defined range that has the outstanding checks, and if it find a match, enter the amount it cleared for. I would copy this for each row.

So, on the outstanding list range Column A is Check number, Column B is Check amount. Column C would I suppose have the desired formula that searches another sheet that has the cleared check numbers and if found, drops the amount listed to the right of that.

Aside from figuring out how best to achieve this thru proper formula, my thought was both have to be formatted the same in order for the formula to work. Any ideas as to how to set this up?

If all the accounts start with a double zeros and are 8 digits in length, you could do something like =Right(A1,6) and copy down (assuming the data is in A1)

If I edit the first report(current outstanding list) that may or may not preface check numbers to include two zeros, and eliminate the zeros, a simple vlookup works to find the corresponding check number in the rangename CLEARED(which I import from the bank statement). Unfortunately, due to the amount of checks that may be formatted to include two zeros before the actual check number, can be very time consuming considering over 1000 checks. Im just trying to figure out the best way to eliminate checks that have cleared from one report by looking for the check number/amount in another reports rangename.

..................