Where can you use custom number formats?

Many areas in Excel support number formats. You can use them in tables, charts, pivot tables, formulas, and directly on the worksheet.

  • Worksheet – format cells dialog
  • Pivot Tables – via value field settings
  • Charts – data labels and axis options
  • Formulas – via the Text Funtion