Excel 2010 Bible

Chapter 24: Using Custom Number Formats 559 Code Comments “text” Displays the text inside the double quotation marks. @ Text pla ...

Part IV: Using Advanced Excel Features 560 Custom Number Format Examples The remainder of this chapter consists of useful exampl ...

Chapter 24: Using Custom Number Formats 561 TABLE 24.5 Examples of Displaying Values in Thousands Value Number Format Display 12 ...

Part IV: Using Advanced Excel Features 562 Displaying values in millions The following format string displays values in millions ...

Chapter 24: Using Custom Number Formats 563 Value Number Format Display 5000000 #,###,,”M” 5M –5000000 #,###,,”M” –5M 0 #,###,,” ...

Part IV: Using Advanced Excel Features 564 Displaying leading zeros To display leading zeros, create a custom number format that ...

Chapter 24: Using Custom Number Formats 565 You can use a custom format string to create other fractional formats. For example, ...

Part IV: Using Advanced Excel Features 566 To make the negative numbers more prominent, you can add a color code to the negative ...

Chapter 24: Using Custom Number Formats 567 Here’s another example that displays text before the number: “Average: “0.00 If you ...

Part IV: Using Advanced Excel Features 568 Filling a cell with a repeating character The asterisk (*) symbol specifies a repeati ...

569 CHAPTER Using Data Validation IN THIS CHAPTER An overview of Excel’s data validation feature Practical examples of using dat ...

Part IV: Using Advanced Excel Features 570 Excel makes it easy to specify the validation criteria, and you can also use a formul ...

Chapter 25: Using Data Validation 571 Specify the conditions by using the displayed controls. Your selection in Step 4 deter- m ...

Part IV: Using Advanced Excel Features 572 l (^) Text Length: The length of the data (number of characters) is limited. You spec ...

Chapter 25: Using Data Validation 573 Creating a Drop-Down List Perhaps one of the most common uses of data validation is to cre ...

Part IV: Using Advanced Excel Features 574 Using Formulas for Data Validation Rules For simple data validation, the data validat ...

Chapter 25: Using Data Validation 575 would contain the same data validation formula. Because you entered a relative cell refere ...

Part IV: Using Advanced Excel Features 576 On the CD All the examples in this section are available on the companion CD-ROM. The ...

Chapter 25: Using Data Validation 577 FIGURE 25.6 Using data validation to prevent duplicate entries in a range. Accepting text ...

Part IV: Using Advanced Excel Features 578 Accepting only values that don’t exceed a total Figure 25.7 shows a simple budget wor ...