tailieunhanh - Excel 2002 Formulas phần 10

N Tuỳ chỉnh chức năng tính toán hoa hồng bán hàng N chức năng tùy chỉnh cho các thao tác văn bản N chức năng tùy chỉnh để đếm, tổng hợp các tế bào N chức năng tùy chỉnh mà đối phó với ngày Quốc hội ví dụ chức năng tùy chỉnh để trả lại các tế bào nonempty cuối cùng trong một | Appendix C Using Custom Number Formats 739 This custom number format has five placeholders and displays the value with five digits no decimal point . This is a good format to use when the cell holds a zip code in fact this is the code actually used by the ZIP Code format in the Special category . When you format the cell with this number format and then enter a zip code such as 06604 Bridgeport CT the value is displayed with the leading zero. If you enter this number into a cell with the General number format it displays 6604 no leading zero . Scroll through the list of number formats in the Custom category in the Format Cells dialog box to see many more examples. In many cases you can use one of these codes as a starting point and only slight customization will be needed. Parts of a Number Format String A custom format string enables you to specify different format codes for positive numbers negative numbers zero values and text. You do so by separating the codes with a semicolon. The codes are arranged in the following structure Positive format Negative format Zero format Text format If you use only one section the format string applies to all values. If you use two sections the first section applies to positive values and zeros the second to negative values. If you use three sections the first section applies to positive values the second to negative values and the third to zeros. The following is an example of a custom number format that specifies a different format for each of these types Green General Red General Black General Blue General This example takes advantage of the fact that colors have special codes. A cell formatted with this custom number format displays its contents in a different color depending on the value. When a cell is formatted with this custom number format a positive number is green a negative number is red a zero is black and text is blue. If you want to apply cell formatting automatically such as text or background color based on the