In the Type list, select an existing format, or type a new one in the box.

Create and build a custom numeric format to show your numbers as percentages, currency, dates, and more. To learn more about how to change number format codes, see Review guidelines for customizing a number format .

Excel provides many options for displaying numbers in different formats like percentages, currency, and dates. If the built-in formats don’t work for your needs, you might want to create a custom number format.

You can’t create custom formats in Excel for the web but if you have the Excel desktop application, you can click the Open in Excel button to open the workbook and create them. For more information, see Create a custom number format.