Number Format

Default number formats.

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.


Number format: General

āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āϘāϰ⧇ āĻĄāĻŋāĻĢāĻ˛ā§āϟ āϏāĻ‚āĻ–ā§āϝāĻžāϰ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ āĻ•āĻžāĻ°ā§āϝāĻ•āϰ āĻ•āϰāĻž āĻšā§ŸāĨ¤

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format - General.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.

From toolbars:

Icon General Number Format

Number Format: General

From the keyboard:

+ Shift + 6


Number format: Number

Applies the default decimal number format to the selected cells.

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format - Number.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.

From toolbars:

Icon Number format: Number

Number format: Number

From the keyboard:

+ Shift + 1


Number format: Percent

āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āϘāϰ⧇ āĻļāϤāĻ•āϰāĻžāϰ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ āĻ•āĻžāĻ°ā§āϝāĻ•āϰ āĻ•āϰāĻž āĻšā§ŸāĨ¤

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format - Percent.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.

From toolbars:

Icon Number Format: Percent

āϏāĻ‚āĻ–ā§āϝāĻžāϰ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ: āĻļāϤāĻ•āϰāĻž

From the keyboard:

+ Shift + 5


Number format: Currency

āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āϘāϰ⧇ āĻŽā§āĻĻā§āϰāĻžāϰ āĻĄāĻŋāĻĢāĻ˛ā§āϟ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ āĻ•āĻžāĻ°ā§āϝāĻ•āϰ āĻ•āϰ⧇āĨ¤

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format - Currency.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.

From toolbars:

Currency Number Format Icon

āϏāĻ‚āĻ–ā§āϝāĻžāϰ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ: āĻŽā§āĻĻā§āϰāĻž

From the keyboard:

+ Shift + 4


Number Format : Date

Applies the default date format to the selected cells.

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format - Date.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.

From toolbars:

Icon Number Format : Date

āύāĻŽā§āĻŦāϰ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ : āϤāĻžāϰāĻŋāĻ–

From the keyboard:

+ Shift + 3


Number Format: Time

Applies the default time format to the selected cells.

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format - Time.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.

From toolbars:

Icon Number Format: Time

āϏāĻ‚āĻ–ā§āϝāĻžāϰ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ: āϏāĻŽāϝāĻŧ


Number Format: Scientific

Applies the default scientific format to the selected cells.

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format - Scientific.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.

From toolbars:

Icon Number Format: Scientific

Number Format: Scientific

From the keyboard:

+ Shift + 2


Number Format: Thousands Separator

Applies the thousand separator to the number in the selected cells.

āĻāχ āύāĻŋāĻ°ā§āĻĻ⧇āĻļāĻžāĻŦāϞ⧀āϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāϤ⧇...

From the menu bar:

Choose Format - Number Format - Thousands Separator.

From the tabbed interface:

Choose Home.

From the sidebar:

Access the Number Format panel of the Properties deck.

From toolbars:

Icon Number Format: Thousands Separator

Number Format: Thousands Separator


Number Format: Delete Decimal Place

āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āϘāϰ⧇āϰ āϏāĻ‚āĻ–ā§āϝāĻž āĻĨ⧇āϕ⧇ āĻāĻ•āϟāĻŋ āĻĄā§‡āϏāĻŋāĻŽāĻžāϞ āĻ¸ā§āĻĨāĻžāύ āĻŽā§āϛ⧇ āĻĻ⧇āϝāĻŧāĻž āĻšā§ŸāĨ¤

Icon Delete Decimal Place

āϏāĻ‚āĻ–ā§āϝāĻžāϰ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ: āĻĄā§‡āϏāĻŋāĻŽāĻžāϞ āĻ¸ā§āĻĨāĻžāύ āĻŽā§āϛ⧇ āĻĢ⧇āϞāĻž āĻšāĻŦ⧇

Number Format: Add Decimal Place

āύāĻŋāĻ°ā§āĻŦāĻžāϚāĻŋāϤ āϘāϰ⧇āϰ āϏāĻ‚āĻ–ā§āϝāĻžāϰ āϏāĻžāĻĨ⧇ āĻāĻ•āϟāĻŋ āĻĄā§‡āϏāĻŋāĻŽāĻžāϞ āĻ¸ā§āĻĨāĻžāύ āϝ⧋āĻ— āĻ•āϰāĻž āĻšā§ŸāĨ¤

Icon Add Decimal Place

āϏāĻ‚āĻ–ā§āϝāĻžāϰ āĻŦāĻŋāĻ¨ā§āϝāĻžāϏ: āĻĄā§‡āϏāĻŋāĻŽāĻžāϞ āĻ¸ā§āĻĨāĻžāύ āϝ⧋āĻ— āĻ•āϰāĻž āĻšāĻŦ⧇

Please support us!