What does control the format of the dropdown options in data validation. Especally if the dropdown is an indirect to another workbook? We are getting inconsistant results.
