I'm writing a very simple formula:
="Stuff: "&A1
A1 has a percentage "79%".
What I want it to display is Stuff: 79%
What it actually displays is Stuff: 0.79
All cells are set to display percentiles. Something about the formula is disabling that. How do I get the desired presentation?
Last edited by Incendax; 12-08-2014 at 08:04 AM.
Insert a helper column and change the percentage format in A1 using the formula below. Then use your concatenate formula referencing the text result below.
Formula:
Please Login or Register to view this content.
one way to get around it;
=CONCATENATE("Stuff: ",VALUE(A1)*100,"%")
If I may suggest a simplified solution,Originally Posted by hoyasaxa215
Insert a helper column and change the percentage format in A1 using the formula below. Then use your concatenate formula referencing the text result below.
Formula:Please Login or Register to view this content.
This will do the same thing without the need for a helper column.
="Stuff: "&TEXT(A1,"0%")
Last edited by Speshul; 12-09-2014 at 10:20 AM.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks