Changing the Number Formatting in Excel 2010

In this article, we will learn how to change the number formatting in Excel.

 

Number formats can be used to change the way Excel displays numbers, text, date & time in cells. When you apply a number format to a cell, you are actually not changing or modifying the original value itself. You are only changing the way the value will get displayed on the worksheet.

 

Number format can be found in Excel in Home ribbon under Number group.
 
img1
 
You can select the following built-in number format options:

 

  • Dollar $ (used as currency symbol, this will apply Dollar symbol in front of the value)
  • Percentage % (used for percentages)
  • Comma , (used to format with a thousand separator)
  • Increase & Decrease Decimal

 

Example of Dollar $ symbol used:

  • Enter any value in cell A1
  • Click on Dollar symbol

 
img2
 

  • In formula bar, you can see the actual number is 20.

 

Example of Decrease Decimal:

 

  • Click on Decrease Decimal twice. This will remove the digits after decimal points.

 
img3
 
When you type data in a cell which is using General format, Excel in its background will figure out whether built-in number formats can be applied or not.

A number format uses symbols & codes to display a value on the worksheet. Microsoft Excel provides a variety of built-in number formats for percentages, fractions, currency, dates, times and other numbers.

General format is the default number format for all cells. A number will appear as integer that uses the General format.

If we are using a longer number than width of the cell & using General format then the cell will appear as number in scientific notation for example: 4.54E+04.

A custom number format allows you to change the way you want to see numbers into date, time.
 

Take an example: If you type a number that starts with a dollar sign or ends with a percentage sign, Excel will figure out the best suitable format for the number & will apply to the cell by changing the cell number format from General to a currency format or a percentage format.
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube