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.

Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.