displays
 

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!

displays
 

hi
see your other post

Regards
FSt1

"Karen" wrote:

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!

displays
 

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)

On Sat, 18 Apr 2009 16:41:01 -0700, Karen
wrote:

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!