Reply to thread

Message: [QUOTE="JE McGimpsey, post: 6787984"] I guess I'm not sure what you're trying to illustrate. If you have results of a formula, the value will be either numeric or text, depending on the output type of the formula. For instance: A1: 5 B1: 10 C1: =A1/B1 will return numeric 0.5, which you can format as 0.0% to give 50.0%. OTOH, C1: =TEXT(A1/B1,"0.0%") will return a Text 50.0% that will be completely unresponsive to number format. Your Lookup(1,rng) example will find only numeric 1, not text. Once a value is entered as Text, however (often the result when data from a web page is pasted in, for example), it's Text until and unless it's coerced into a number, no matter what the format. [/QUOTE]