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


etc. But in the actual dropdown menu, they appear unformatted, like


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?


AFAIK, at this time it's not possible to apply the desired format (0.00), but other formats like date, percentage works fine. Currency also doesn't work.

|improve this answer|||||
  • Wow that's highly unfortunate. By chance do you have any link or citation for that information? – JVC Aug 29 '16 at 18:06
  • I don't have any link or citation, that is why I started my answer with AFAIK . – Rubén Aug 29 '16 at 18:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.