This sample demonstrates number formatting feature with a restaurant invoice.
DEMO
DOCUMENTATION
SOURCE
In this demo, number formatting is applied to specific cells by using the format property,
and a range of cells by using the numberFormat method.
In the Amount column, we have used Custom number formatting to highlight the values less than 350 and greater than 350 with red and blue colors respectively.
Key Features
- Built-in number formats - Format values as numbers, currency, accounting, percentage, dates, times, fractions, scientific notation, and text for improved readability.
- Custom number formatting - Create custom format patterns to control how data is displayed based on specific business and reporting requirements.
- Culture-aware formatting - Support locale-specific date, time, currency, accounting, decimal, and thousands-separator formats for global applications.
Learn how to apply built-in and custom number formats to cells and ranges, as demonstrated in this sample.
Documentation Links
More Resource