Excel Theatre Blog Rotating Header Image

Excel formatting

Excel Numbers Do Not Sum Correctly

If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect.

This video shows the simple steps to change the text "numbers" to real numbers. For written instructions, visit Convert Text to Numbers

______________________

Move the Excel 2003 Color Palette

In Excel 2003, or earlier versions, you can move the color and border palettes close to the cells you’re formatting.

To see the steps, watch this short Excel video tutorial.

For written instructions, see the move the color and border palettes in Excel notes on the Contextures website.

 

______