Open the Excel 2010 file that contains the phone numbers you want to change. Click on the cell that contains the phone number, or click on the range of cells if you want to change the format for ...

The solution is to use a custom format to reinstate the zeros. So, if you have five digit product numbers, select the cells containing the product numbers, choose Format > Cells > Number tab, and ...

If you are unaware of Microsoft Excel's "Format Cells" option, then you will discover it offers a wealth of formatting possibilities. Aside from the many built-in number formats, Excel allows you ...

In Excel, you can format a negative number by creating a Conditional Formatting rule. Select the range of cells containing the numbers. On the Home tab, in the Styles group, ...

Microsoft Office Excel can be configured to display a number with the default currency symbol. In addition to the options for currency symbols, the format has options for the number of decimal ...