Converting Numeric Option Value to Text

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Give it a try. You can unsubscribe at any time.

A reader suggests another way to convert a numeric option value to text.

In AW 7.12 I suggested using the Switch function to convert numeric values from a choice in an option group to text values.  Tom Bushaw writes to suggest another possibility, the Choose function.  The Choose function yields a value (such as a text value) based on a numeric value.  Thus, it is ideally suited for converting a numeric option value to text.  The Switch function will do this too, but it is not limited to converting numeric values to text (or other data types).