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.

For Excel to divide the values, however, the cell must contain a delimiter, a character that specifies where the first number ends and the second one begins.