数字/格式
类别
Select a category from the list, and then select a formatting style in the Format box.
单元格默认的货币格式取决于操作系统的地区设置。
格式
Select how you want the contents of the selected cell(s) to be displayed. The code for the selected option is displayed in the Format Code box.
货币分类列表框
选择币种,然后滚动到格式列表的顶部以查看该货币的格式化选项。
货币的格式码采用 [$xxx-nnn] 的格式,其中 xxx 为货币符号,nnn 为国家/地区代码。有些特殊的银行符号,例如欧元所用的 EUR,则不需要国家/地区代码。货币格式不受语言框中所选语言的影响。
语言
Specifies the language setting for the selected cells fields. With the language set to Automatic, LibreOffice automatically applies the number formats associated with the system default language. Select any language to fix the settings for the selected cells fields.
语言设置能够确保当在使用其他默认语言设置的操作系统中打开文档时,文档中的日期和货币仍保留原有格式。
源格式
Uses the same number format as the cells containing the data for the chart.
选项
指定选定格式的选项。
小数位数
Enter the number of decimal places that you want to display.
分母位数
分数格式下,要显示的分母位数。
前导零
Enter the maximum number of zeroes to display in front of the decimal point.
负数为红色
Changes the font color of negative numbers to red.
使用千位分隔符
Inserts a separator between thousands. The type of separator that is used depends on your language settings.
Engineering notation
With scientific format, Engineering notation ensures that exponent is a multiple of 3.
格式码
Displays the number format code for the selected format. You can also enter a custom format. The following options are only available for user-defined number formats.
添加
Adds the number format code that you entered to the user-defined category.
删除
Deletes the selected number format. The changes are effective after you restart LibreOffice.
编辑注释
Adds a comment to the selected number format.
名称行
Enter a comment for the selected number format, and then click outside this box.