Archive of Mr Excel Message Board


Back to Edit in Excel archive index
Back to archive home

add percentage to sheet

Posted by Paul Zwierzanski on September 12, 2001 11:23 AM
Hi There

Is it possible to add a percentage to ALL the numeric
data cells on a worksheet?

Thanks in advance

Paul


Re: add percentage to sheet

Posted by Tom Urtis on September 12, 2001 12:58 PM
You can enter the percentage number in a cell of your choice, copy that cell, then hilite the numeric data cells you mention, and click Edit > Paste special > select "Add" in the Operation section, and click OK.

Tom Urtis


Re: add percentage to sheet

Posted by Juan Pablo on September 12, 2001 1:00 PM
Well, i don't know if this help you, but try this...

First, in another sheet, type 100.
Second, copy this value, go to the sheet that you want, select edition - go to - special, and select constants.

Next, select edition - paste special - operation - divide.

Next, click on the "%" button on the format toolbar.

Now, again, select edition - go to - special, and select formulas and choose ONLY Numbers.

Edition - Paste special - Operation - Divide.

And click on the "%" button on the tool bar...

That should.. i think... do it.

Any help ?

Juan Pablo


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.