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.

Adding text after a specific number of characters in Excel is a possibility if you know what to do. In this situation, we will be using the LEFT, RIGHT, and LEN functions instead of CONCAT.