[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Charts and Graphics
  [Expand]Mail Merge
  [Collapse]Examples
   [Expand]Files
   [Expand]Workbooks
   [Expand]Worksheets
   [Expand]Rows and Columns
   [Expand]Cells
   [Expand]Formulas
   [Expand]Import and Export Data
   [Expand]Data Binding
    Sorting
   [Expand]Mail Merge
    Search
   [Expand]Shapes
   [Expand]Charts
   [Expand]Sparklines
   [Collapse]Formatting Cells
     How to: Apply a Style to a Cell or Range of Cells
     How to: Create or Modify a Style
     How to: Format a Cell or Range of Cells
     How to: Apply Rich Formatting to Cell Text
     How to: Specify Number or Date Format for Cell Content
     How to: Change Cell Font and Background Color
     How to: Configure Cell Font Settings
     How to: Align Cell Content
     How to: Add and Remove Cell Borders
     How to: Clear Cell Formatting
   [Expand]Conditional Formatting
   [Expand]Group Data
   [Expand]Filter Data
   [Expand]Tables
   [Expand]Pivot Tables
   [Expand]Printing
   [Expand]Pictures
   [Expand]Protection
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Specify Number or Date Format for Cell Content

You can specify how to display numeric values in cells by applying number formats. For example, a number can appear in a cell as a percentage, decimal, currency, accounting, date or time value. To apply a number format to a cell or cell range, assign the corresponding number format code to the Formatting.NumberFormat property of the cell or cell range object. This document provides examples on how to apply different number formats to display cell content as date and time and as percentage, currency and decimal values, and how to create custom number formats.

Expanded Date and Time Formats

This example demonstrates how to specify different display formats for date and time values in cells.

The image below shows the different formats used to display date and time values in cells (the workbook is opened in Microsoft® Excel®).

Expanded Number Formats

This example demonstrates how to use different number formats to display numeric values in cells.

The image below shows the different formats used to display numbers in cells (the workbook is opened in Microsoft® Excel®).

Expanded Custom Number Formats

This example demonstrates how to create a custom number format to display positive numbers, negative numbers, zero and text values using different formats and colors. To do this, specify the appropriate code sections of the number format as required. These code sections are separated by semicolons and used in the following order.

<POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>

The image below shows how different values are displayed in cells when a custom number format is applied (the workbook is opened in Microsoft® Excel®).

Expanded See Also

Is this topic helpful?​​​​​​​