Hello,
I have over 15 years experience writing Excel spreadsheet solutions for business and personal use.
I gather that you wish to have some way to take the data contained in a Google Sheet, replace the leading zeros and ensure the text is 11 characters, with any difference in length being validated, for example, text in red, or "INVALID" showing in the cell.
Your proposal sounds easily achievable and I would be happy to collaborate with you in due course regarding the project.
I hope to hear from you soon,
Kind regards,
Chris James