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.
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
- 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.
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.