Number Formatting (Home)

Question 1

Number Formatting (General)

Answer 1

Default number format, displayed as entered.

Where to Find:
Home tab → Number group → Select ‘General’ from the dropdown.

Question 2

Currency (Number Format)

Answer 2

Formats numbers as monetary values.

Where to Find:
Home tab → Number group → Select ‘Currency’ from the dropdown.

Question 3

Percentage

Answer 3

Multiplies by 100 and displays as a percentage.

Where to Find:
Home tab → Number group → Select ‘Percentage’ from the dropdown.

Question 4

Decimal Places

Answer 4

Increase/Decrease the number of decimals.

Where to Find:
Home tab → Number group → Use the Increase/Decrease Decimal buttons.

Question 5

Scientific ( Number Group)

Answer 5

For large or small numbers (e.g., 1.23E+08).

Where to Find:
Home tab → Number group → Select ‘Scientific’ from the dropdown.

Question 6

Date & Time

Answer 6

Display numbers as dates or time values.

Where to Find:
Home tab → Number group → Select ‘Date’ or ‘Time’ from the dropdown.

Question 7

Text (Numbers Group)

Answer 7

Treats numbers as text (useful for ZIP codes, phone numbers).

Where to Find:
Home tab → Number group → Select ‘Text’ from the dropdown.