EXCEL单元格格式代码(外国英文资料).docVIP

EXCEL单元格格式代码 EXCEL cell format code Custom definition of cell format 1, G/ general format: regular numeric display, equivalent to the classification list in the general option. Example: Code: G/ general format. 10 shows 10 and 10.1 shows 10.1. 2, #: digital placeholder. A meaningful zero without showing meaningless zero. The number of decimal numbers such as more than #, according to the # number four to five homes. Example: Code: ###.##, 12.1 showed 12.10; 12.1263 shows: 12.13 3, 0, digital placeholders. If the content of the cell is greater than the placeholder, the actual number is displaye