Number Format

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

이 명령을 사용하려면...

From the keyboard:

+ 1

From the sidebar:

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

Icon Properties

속성


Format as Number

선택한 셀에 기본 숫자 서식을 적용합니다.

Icon General Number Format

형식: 숫자

Format as Percent

선택한 셀에 백분율 서식을 적용합니다.

Icon Number Format: Percent

형식: 백분율

Format as Currency

선택한 셀에 기본 통화 서식을 적용합니다.

Currency Number Format Icon

형식: 통화

note

셀의 기본 통화 서식은 운영 체제의 지역 설정에 의해 결정됩니다.


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

Enter the number of decimal places that you want to display.

Leading zeroes

Enter the maximum number of zeroes to display in front of the decimal point.

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!