You can add a zero before a number in Google Sheets and Excel using this tutorial. You need to change cell formatting or use function.

3] Add text after a set number of characters Adding text after a specific number of characters in Excel is a possibility if you know what to do.

Excel has a surprising limitation that you may not discover until you try to enter more than 15 digits in a cell. The application can only store numbers with15 digits of precision.