Is there a way to use a dropdown box to change a CONVERT formula? What i am looking to do is have the dropdown list contain the words "mile, yard, feet, inch, meter, etc" and when one is sleceted the formula of =CONVERT(A1,"mi","ft"), will adjust at the "mi" part of the code to what ever is selected via the dropdown list.
Bookmarks