Number Format

Use the Number Format panel to set the number format for a cell or range.

Pre prístup k tomuto príkazu...

From the keyboard:

+ 1

From the sidebar:

Open the Properties sidebar deck and expand the Number Format pane.

Icon Properties

Vlastnosti


Format as Number

Použije východzí formát čísla na označené bunky.

Icon General Number Format

Formátovať ako číslo

Format as Percent

Použije formát meny na označené bunky.

Icon Number Format: Percent

Formátovať ako percento

Format as Currency

Použije prednastavený formát meny na označené bunky.

Currency Number Format Icon

Formátovať ako menu

note

The default currency format for a cell is determined by the regional settings of your operating system.


To apply a different currency format, click the Format as Currency icon, select a currency from the list, and click OK.

Category

Select a default format from the dropdown list.

Decimal places

Zadajte počet desatinných miest, ktoré chcete zobraziť.

Leading zeroes

Zadajte maximálny počet núl, ktoré sa majú zobraziť pred desatinnou čiarkou.

Negative numbers red

Changes the font color of negative numbers to red.

Thousands separator

Inserts a separator between thousands. The type of separator that is used depends on your locale settings.

Engineering notation

With scientific format, Engineering notation ensures that exponent is a multiple of 3.

Please support us!