[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Format as Percent

Posted on 2012-03-29
3
Medium Priority
?
292 Views
Last Modified: 2012-03-29
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
Comment
Question by:pdvsa
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
kgerb earned 2000 total points
ID: 37784405
How about this?

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

Kyle
0
 

Author Closing Comment

by:pdvsa
ID: 37784515
perfect!  thank you
0
 
LVL 12

Expert Comment

by:kgerb
ID: 37785289
You're welcome.  Glad to help.
Kyle
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question