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

EXCEL单元格格式代码 EXCEL cell format code A custom detail in the cell format G/general format : the normal option in the classification list is displayed in a regular number. Example: code: G/general format. 10 shows for 10; The 10.1 is shown as 10.1. # : digital placeholder. Only meaningful zero without showing meaningless zero. The number of Numbers greater than # after the decimal point is rounded in the number of #. Example: code: # # # # #, 12.1 shows 12.10; 12.1263 shows: 12.13 0 : digital placeholder. If the content of the cell is greater than the placeholder, the actual number is displayed,