Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean ...

To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...