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.

How to Convert Decimals to Binary Numbers Using Excel. Decimal notation describes numbers using the digits 1 through 10. Binary notation describes them using just two digits, 1 and 0, where each ...

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.