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:

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:

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:

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:

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:

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:

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:

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:

Number Format: Thousands Separator

Number Format: Delete Decimal Place

Eemaldab valitud lahtrites olevatelt arvudelt ühe kümnendkoha.

Arvuvorming: kustuta kümnendkoht

Number Format: Add Decimal Place

Lisab valitud lahtrites olevatele arvudele ühe kümnendkoha.

Arvuvorming: lisa kümnendkoht

Vormindus - Lahtrid - Arvud.