推荐!---EXCEL单元格的数字格式设置（国外英文资料）.docVIP

推荐!---EXCEL单元格的数字格式设置（国外英文资料） Here are some tips from Excel XP, but my question is whether there is any more advanced usage! Create or remove a custom digital format from the custom digital format to choose the cell that you want to format. On the format menu, click cell and click the number TAB. In the classification in the list, click the category, similar to the required format set up similar to the required format of the built-in format (dont need to change the built-in format, you can create a custom backup). In the classification list, click customize. In the type box, edit the digital format code to create the required format. You can specify up to four sections in the formatting code. These format codes are separated by semicolons, which define the positive, negative, zero, and text in the format. If only two sections are specified, the first part is used to represent positive and zero, and the second is used to represent negative Numbers. If only one section is specified, the section is used for all the Numbers. If you want to skip a section, use the semicolon for that section. The format code can be used to describe how to display the following: Numbers, dates, time, money, percentage, or scientific notation, as well as text or space. Format code text displays the text and Numbers and Spaces To display text and figures at the same time, in the cell can be text characters enclosed in double quotation marks ( ), or in front of a single character with a backslash (\). The characters should be placed in the appropriate parts of the format code. Type format, for example, $0.00 surplus ; $0.00 shortage, to show a surplus $125.74 comes at a time and a shortage of $125.74 negative. The following characters do not use quotation marks: $, -, +, /, (), :. And ^, , (single quotation marks from left), single quotes (right), ~, {}, =, , , and Spaces. Including the text input section, if the text part is included, the text section is always the last part of the digital