Excel Guides

Adding a Custom Format to those Offered by Excel in Excel

You can add a custom format to those offered by Excel in Excel by following these steps:

  1. Open the Format Cells dialog box by pressing Ctrl+1, or by right-clicking on the cell and selecting Format Cells from the context menu.
  2. Select the Number tab, if it is not already selected.
  3. From the Category list, select Custom. This will display the Custom category options.

  4. In the "Type:"
    text box, type the number format you want.

    For example, to display a number with two decimal places and a thousands separator, type: #,##0.00.

    To display a date in mm/dd/yyyy format, type: m/d/yyyy.

    To display a time in hh:mm AM/PM format, type: h:mm AM/PM.

    You can also use custom formats to display numbers as percentages, currency, and so on. For more information about the available options, see Create or delete a custom number format.

    5. When you are finished creating your custom format, click OK.

    Your custom format will now be available for use in Excel.

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.