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?

1 Answer 1


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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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