Explanation

Number formatting changes how values are displayed without necessarily changing the underlying value.

Common Number Formats

General: Default format.

Number: Displays numbers with number formatting and decimal options.

Currency: Displays values as currency.

Accounting: Displays monetary values using accounting-style alignment.

Date: Displays dates in different date formats.

Time: Displays time values.

Percentage: Displays values as percentages.

Fraction: Displays numbers as fractions.

Scientific: Displays very large or very small numbers in scientific notation.

Custom Number Format

Custom formatting allows you to control how values are displayed according to your requirements.

Decimal Places

You can increase or decrease the number of decimal places displayed.

Example

0.75 can be displayed as:

75%

when the value is appropriately formatted as a percentage.

Practice

Create a table containing:

  • Student marks
  • Percentage
  • Fees
  • Date of Birth
  • Exam Time

Apply the appropriate number format to each column.

PreviousNext