Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

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
0
pdvsa
Asked:
pdvsa
  • 2
1 Solution
 
kgerbChief EngineerCommented:
How about this?

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

Kyle
0
 
pdvsaAuthor Commented:
perfect!  thank you
0
 
kgerbChief EngineerCommented:
You're welcome.  Glad to help.
Kyle
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now