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!