strip out padding

[seansr]

I am importing a product list including Barcodes from one system to another. The old system padded the barcodes to 16 digits when should be 13

see two examples below the top one has 3 leading zeros when actually the barcode starts with 87

0008711000334232

5010035062978

If there a quick way to strip out any 0 padding before the number. Barcodes can start with any number but rarely a zero but should be no more than the 13 digits

 

[shrivallabha]

If it is always numeric then you can do any math operation to get rid of leading zeroes.
e.g.
In cell B1:
=A1+0
or
=A1*1
or
=A1/1
etc.