Removing leading zeros in code

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

If you want to keep the zeros in the cell you can click on the cell or range of cells that it would apply to and change the format to show as follows:

"00000000"

Just enter that in the "Type" field and you should get the desired result.

Hope that helps.

The problem is that your second set (which was originally showing up without the leading zeros) is being seen as numbers and the other set that it is being compared to is being seen as Text. You need to convert everything either to all text or all numbers.

ChemistB