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

See Also

• Getting Text Values from an Option Group

Want More?

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

Windows 10 Creators from people 'in the know'

A detailed and independent look at Windows 10, especially written for the many people who use Microsoft Office.

Fully up-to-date with coverage of the Creators edition 2016 major update of Windows 10.

This 720 page book shows you important features and details for all serious Windows 10 users.

Email address (required, obviously)

Join Office Watch

We never share your email address with anyone - never have, never will. Privacy Policy.