displays

K

Karen

My question is more on how to display the percentage. I'm calculating
percentages. my formula is G2*J2. My percentage is displaying 1.01 ( which
is 1% increase. I'm trying to format the column, (it's now formated to
general)...if I format to "percentage" format, my column displays 101.00%..
How can I format my cells to display 1% and still maintain my formula of
G2*J2. I've messed with the decimal places, percentage, etc. Not sure what
to do. Probably a very simple question, but I do not use excell very often.
Thanks for your help!
 
C

Chip Pearson

You can't because 1.01 is in no way representable as 1%. They are
different numbers, 1.01 and 0.01. It is like asking how the display 5
as 7. Nonsensical. You would need to use an additional cell to
calculate the 0.01 and then format that cell as you want.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentages 2
MS Project. Real progress of the project, % complete 1
Multiple Formula Custom Formatting 4
Negative percentage in data verification dropdown list? 3
Would like to input 3 letters into a cell, each having a different numerical value 5
Number range as a percentage 2
If statement with multiple criteria and multiple results 3
Formatting Percentages/LOOKUP using a Percentage 5

Top