Leading zeros in product ID for catalog items

Hi,

Does anyone know why some product IDs in the catalog have leading zeros while some don't? It's a hassle to the users to add a wildcard character in the product ID when searching for items in the catalog just because the product ID format is inconsistent. How do we correct the existing catalog items with leading zeros in the product ID and how do we prevent this from happening again.

Many thanks,

Joy