Right function

Hi,   Is there a way for the right function to omit zeros from the start of the findings? My example is: we use the last digits of our item codes to generate a batch number; the format always star...