Similarly, it's easy to forget to type the currency symbol when you're focusing on the numbers that follow, so using Excel's built-in number format converter is the way forward.

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 ...