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.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

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.

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

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