O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

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

Applying Numeric Formatting

THE NUMBER GROUP OF THE HOME tab offers tools for controlling how Excel displays— you guessed it—numbers. From currency to percentages, all the basic tools are here, as shown in Figure 5-28.

Figure 5-28. Got money? A date or time? Use the Number group of the Home tab to make your numbers look like what they really are.

To apply these formats to your numeric content, select the cells to which the formatting should apply, and then choose from the following buttons:

  • Number Format. This button displays the default or current formatting in place for the selected cells. If you click the button arrow, a menu displays, ...

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