Creating Custom Number and Date Formats

Creating Custom Number and Date Formats

Number Formatting

1. Select cell or range containing the number to format. 
2. Go to Home tab and select Number category from Number group.

Decimal Point Display

1. Select cell or range containing a number to format. 
2. Select Increase Decimal or Decrease Decimal from Number group.

Applying and Removing Comma Style Formatting (To Indicate Thousands)

1. Select cell or range containing the number to format.
2. Select Comma style from Number group.
3. The number will be formatted with thousand separator and 2 decimal points

Currency Symbol

1. Select cell or range containing the number to format. 
2. Select Accounting Number Format from Number group. 
3. The number will be formatted with thousand separator, 2 decimal points and default currency symbol based on the default language set. 
4. To choose other currency, click the pull-down button next to the function and select More Accounting Formats.

Percentages

1. Select cell or range containing the number to format.
2. Select Percent Style from Number group.

Date Styles

When you type something like 2/2 in a cell, Excel knows you’re typing a date and formats it based on the date setting in Control Panel. Excel might format it as 2-Feb.

To change to different date format 

1. Select cell or range containing date to format. 
2. Select Short Date or Long Date category from Number group. 
   
3. For more date format, click the Number group dialog box launcher and select a style from Date category.