Hope someone can help, I get a report from payroll, all the numbers are 8 digits so if pay ID is 00045551 this is what it displays, I'm trying to reconcile it against something that will not display the leading zeros no matter how we try to format the cells therefore in this spreadsheet it shows the same number as 45551, when I check the numbers against each other in code it errors on these lines as it does not recognise that they are the same number. How can I either remove the leading zeros in one sheet or add them up to the 8 digits in the other.....

Apologies if I've rambled.

Sam