Format as Percent

How can I format this as a percent?

="Free Ratio "&GETPIVOTDATA("Free Ratio ",$A$1,"Facility Bank Name","DNB Nor Bank USA")

It stands as the following now:
Free Ratio 0.709481416141033

Thank you
pdvsaProject financeAsked:
Who is Participating?
kgerbChief EngineerCommented:
How about this?

="Free Ratio " & TEXT(GETPIVOTDATA("Free Ratio ",$A$1,"Facility Bank Name","DNB Nor Bank USA"),"#0.00%")

pdvsaProject financeAuthor Commented:
perfect!  thank you
kgerbChief EngineerCommented:
You're welcome.  Glad to help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.