Skip to content

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

About this author

Office 2024 - all you need to know. Facts & prices for the new Microsoft Office. Do you need it?

Microsoft Office upcoming support end date checklist.