Number Format

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

Per accedir a esta orde...

+ 1

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

Properties

Format as Number

Applies the default number format to the selected cells.

Format as Number

Applies the percentage format to the selected cells.

Format as Percent

Applies the default currency format to the selected cells.

Format as Currency

El format monetari per defecte per a una cel·la el determina la configuració regional del sistema operatiu.

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

Introduïu el nombre de decimals que s'han de mostrar.

Introduïu el nombre màxim de zeros que s'han de mostrar davant de la coma decimal.

Changes the font color of negative numbers to red.

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

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