Excel Guides

Moving Custom Formats to Number Formatting Categories in Excel

When you first open Excel, the default number formatting categories are General, Number, Currency, Accounting, Date, Time, Percentage, and Scientific. However, you can also create custom number formats. To do this, select the cells you want to format and then click on the Home tab. In the Number group, click on the dialog box launcher.

In the Format Cells dialog box, select the Number tab and then click on Custom in the Category list. In the Type box, enter the format code for the type of custom number format you want to create. For example, if you want to create a custom number format that displays four decimal places, you would enter #.#### in the Type box.

Once you have entered the format code in the Type box, click on the OK button to apply the custom number format to your selected cells.

If you want to move a custom number format to one of the default number formatting categories, select the cells that are using the custom number format and then click on the Home tab. In the Number group, click on the dialog box launcher.

In the Format Cells dialog box, select the Number tab and then click on Custom in the Category list. In the Type box, delete the existing format code and then enter one of the following codes for the default category you want to use:

  • General: @
  • Number: 0
  • Currency: $#,##0.00_);($#,##0.00)
  • Accounting: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
  • Date: m/d/yyyy
  • Time: h:mm:ss AM/PM
  • Percentage: 0%
  • Scientific: 0.00E+00

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.