When i am using the function of concatenate and am entering a cell that is formatted as a percentage, I keep getting a result in decimal form. How might I get the result in Percentage form.
The function I am using is Concatenate("kVar required to produce", k2,"Pf") When I enter a value 95% in k2, it shows up as a percentage. When the info is displayed in the listed function it displays as .95 .
Thanks for your help
Last edited by cadamhill; 05-03-2012 at 09:55 AM.
Try
Concatenate("kVar required to produce", text(k2,"0%"),"Pf")
you need to add the TEXT() function.
e.g.
=CONCATENATE("kVar required to produce ", TEXT(K2,"0%")," Pf")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
use below formula
Concatenate("kVar required to produce", text(k2,"0.#%"),"Pf")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks