EXCEL 用千表示数值的方法
2018-09-23 12:10 更新
中国教程网zhangditony翻译，转载请保留此信息 .
1. Press Ctrl+1 to open the Format Cells dialog box.
2. Select the Number tab, and from Category, select Custom.
3. In the Type box, enter the following Custom Formatting syntax:
#,##0.0,;[Red](#,##0.0,);-;
Result:
· Original number: 5,645,625
· The displaying formatting number: 5,645.6
Note:
The number formatting syntax is:
Positive; Negative; 0; Text
2. Select the Number tab, and from Category, select Custom.
3. In the Type box, enter the following Custom Formatting syntax:
#,##0.0,;[Red](#,##0.0,);-;
Result:
· Original number: 5,645,625
· The displaying formatting number: 5,645.6
Note:
The number formatting syntax is:
Positive; Negative; 0; Text
![20070705_84cfcb07c75fbecd2ff7fbbrkxyml7rd[1].jpg](https://atts.w3cschool.cn/attachments/image/20151103/1446546653969459.jpg "1446546653969459.jpg")
以上内容是否对您有帮助：
更多建议：