Number Format

Default number formats.

Selle käsu kasutamiseks...

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

Rakendab valitud lahtritele vaikimisi arvuvormingu.

Selle käsu kasutamiseks...

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.

Selle käsu kasutamiseks...

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

Vormindab valitud lahtrites olevad arvud protsendina.

Selle käsu kasutamiseks...

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

Arvuvorming: protsent

From the keyboard:

+ Shift + 5


Number format: Currency

Rakendab valitud lahtritele vaikimisi rahavormingu.

Selle käsu kasutamiseks...

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

Arvuvorming: raha

From the keyboard:

+ Shift + 4


Number Format : Date

Applies the default date format to the selected cells.

Selle käsu kasutamiseks...

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

Arvuvorming: kuupäev

From the keyboard:

+ Shift + 3


Number Format: Time

Applies the default time format to the selected cells.

Selle käsu kasutamiseks...

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

Arvuvorming: kellaaeg


Number Format: Scientific

Applies the default scientific format to the selected cells.

Selle käsu kasutamiseks...

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.

Selle käsu kasutamiseks...

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

Eemaldab valitud lahtrites olevatelt arvudelt ühe kümnendkoha.

Icon Delete Decimal Place

Arvuvorming: kustuta kümnendkoht

Number Format: Add Decimal Place

Lisab valitud lahtrites olevatele arvudele ühe kümnendkoha.

Icon Add Decimal Place

Arvuvorming: lisa kümnendkoht

Palun toeta meid!