How do I return a percentage value in a cell. I am using Excel 2000. I need to divide the value of two cell and return the percentage with a label before it.
I enter the formula ="Margin " &(A15/C45)
I want the return to look like this: Margin 52%
But, I keep getting this: Margin .52458457856
What is wrong with my formula. Also tried to format cell for percentage, That didn't work ether.
Thank You in advance for any help
I enter the formula ="Margin " &(A15/C45)
I want the return to look like this: Margin 52%
But, I keep getting this: Margin .52458457856
What is wrong with my formula. Also tried to format cell for percentage, That didn't work ether.
Thank You in advance for any help