Solved

I want to display the % value of another cell as 5% instead of showing it as .05 (excel 2003)

Posted on 2011-03-17
5
149 Views
Last Modified: 2012-05-11
I am using the "&" in a formua.

Thanks,
JP
0
Comment
Question by:easycapital
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35156321
use ="some text "&TEXT(A5,"0%")
for example.
0
 

Author Comment

by:easycapital
ID: 35156413
How do I get the rate 4 decimal points?
0
 

Author Comment

by:easycapital
ID: 35156421
for example 5.2234%
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 35156443
="some text "&TEXT(A5,"0.0000%")
0
 

Author Closing Comment

by:easycapital
ID: 35156477
Thanks!  
I was actually adding zeros without the period.  
JP
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

729 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