Number Format

Default number formats.

To access this command...

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

Applies the default number format to the selected cells.

To access this command...

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.

To access this command...

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

Applies the percentage format to the selected cells.

To access this command...

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

Applies the default currency format to the selected cells.

To access this command...

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.

To access this command...

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

Number Format : Date

From the keyboard:

+ Shift + 3


Number Format: Time

Applies the default time format to the selected cells.

To access this command...

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.

To access this command...

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.

To access this command...

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

Removes one decimal place from the numbers in the selected cells.

Icon Delete Decimal Place

Number Format: Delete Decimal Place

Number Format: Add Decimal Place

Adds one decimal place to the numbers in the selected cells.

Icon Add Decimal Place

Number Format: Add Decimal Place

Please support us!