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.

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 use Excel's Chart Wizard to create a chart, by default the chart takes on the number formats used in the worksheet that includes the charted data. Mary Ann Richardson shows you a way to ...