O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ACTIVITY 4-3: Applying Number Formats

Before You Begin

The my_sales_data.xlsx workbook file is open.

Scenario

Your sales data worksheet is looking better and better. But you still see opportunities to make it easier to read. You decide that the worksheet would be easier to interpret if you applied the currency format to the dollar amounts. Also, you feel that adding the date to the worksheet will help give meeting attendees a better idea of how current the information is.

  1. Format the quarterly and total sales data as currency with no decimal places displayed.
    1. Select the range C7:G24.
    2. Select HOME→Number→dialog box launcher.
    3. In the Format Cells dialog box, ensure that the Number tab is selected.
    4. In the Category section, select ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required