"Number Formatting in Excel 2007"

What you know about number formatting?

Number Formats help you to change the appearance of numbers or values in a cell in the Excel spreadsheet. They are not difficult, and can be achieve with a few clicks.

Formatting is done to improve the appearance of the spreadsheet and to make the numbers easier to read and understand. Commonly used number formats include adding commas ( , ), percent symbols ( % ), decimal places, and dollar signs( $ ).

In Excel 2007, the basic number formatting options are located on the Home tab, Number group as shown here.

Excel 2007 number group

To change the basic number formatting

  • Select the cell containing number that you wish to format.
  • Click on the down arrow next to the Number Format drop-down list and select a suitable command.
  • Excel 2007 number format drop down menu


To change number formatting using the formatting icons

  • You can quickly change the formatting of a cell or selected range by using the following icons on the Home tab, Number group.
  • Excel 2007 number formating icons


To format a number as a currency

  • Select the cell or range of cells you want to format.
  • Right-click on the cell and choose Format Cells from the pop-up menu.
  • From the Format Cells dialog box displayed, select the Number tab.
  • Under the Category: section, select Currency.
  • Excel 2007 format cells dialog box

  • Select the number of decimal places you require by using the Decimal places: spin box arrows.
  • In the Symbol: drop down list, select the type of currency.
  • Click OK.


To format a number as a percentage

  • Select the cell or range of cells you wish to format.
  • Right-click on the cell and choose Format Cells from the pop-up menu.
  • From the Format Cells dialog box displayed, select the Number tab.
  • Under the Category: section, select Percentage.
  • Select the number of decimal places you require by using the Decimal places: spin box arrows.
  • Click OK.


To change the number of decimal places

  • Select the cell or range of cells, you wish to change the number of decimal places.
  • To increase a decimal place, click on the Increase Decimal icon on the Home tab, Number group. You can continue to click to increase the decimals as required.
  • To reduce a decimal place, click on the Decrease Decimal icon on the Home tab, Number group. You can continue to click to reduce the decimals as required.


To round numbers using a numeric format

  • Select the cell or range of cells you wish to format.
  • Right-click on the cell and choose Format Cells from the pop-up menu.
  • From the Format Cells dialog box displayed, select the Number tab.
  • In the Category: section, select Number.
  • Select the number of decimal places you require by using the Decimal places spin box arrows.
  • Click OK.


To change colors based on the value in the cells

  • Select the cells you wish to change, which contain numeric values.
  • Right-click on the cell and choose Format Cells from the pop-up menu.
  • From the Format Cells dialog box displayed, select the Number tab.
  • Choose Custom from the Category: list box.
  • Use the scroll bars in the Type: section of the dialog box to view what custom number formats are available.
  • For example, to force all negative numbers to be displayed in red, you would select the option illustrated below.
  • Click OK.
  • Excel 2007 formatting number color


To display negative numbers that enclosed within brackets

  • You would edit the above example, as illustrated.
  • Excel 2007 number formatting bracket


Related Topics:

How to Edit Cell in Excel 2007 and How to Prevent it from Editing?

How to view, create and freely download the Excel 2007 template files?

Discovering the Cells Alignment Options in Microsoft Excel 2007

Adding and Editing the Header or Footer in the Excel 2007 Worksheets

How to Merge and Unmerge Cells in Excel 2007?



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Number formatting info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.