Wish I had found you before I spent $100 to take a class. Thanks!”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2003

Single page view print copy

Formatting Numbers

Challenge!

  • Open your Monthly Budget file.
  • Format the numbers in the spreadsheet as Currency without the $ symbol.
  • Fill the formula from B19 to C19 through N19. This text Challenge 13 Text will appear in cell 19 of columns D through N because expenses have not been entered for those columns yet.
  • Select row 19, and format the numbers as a percent with no decimal places.

    An example:

    Currency and Percent Example

  • Save and close the document.
1 2 3 4 5 6