Converting Numeric Option Value to Text

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).

Want More?

Office Watch has the latest news and tips about Microsoft Office.  Delivered once a week.