I'm using Data Validation to give the user a list of valid prices they can select from. These are on their sheet in "financial" format such as
2.00 2.50 3.00
etc. But in the actual dropdown menu, they appear unformatted, like
2 2.5 3
etc. Once selected however, they do get formatted as financial data because I've formatted that column appropriately.
How can I get the actual dropdown list presented by Data Validation, to be correctly formatted as desired?