0
In Excel how do you add a percentage sign to a list of numbers If you format the numbers it multiplies them all by 100. If you just want to add the percentage sign without changing the values?
Wiki User
∙ 13y ago
Change the formatting of the percent. Right click> Format cells >Custom> 0.00"%">OK. By changing the % to "%" it is changing the percent to a text character instead of an action/formula.
It is not that they are multiplied by 100. Remember that 1 = 100%, so if you format 1 to percentage it becomes 100%, not 1%. .01 is 1%. There is a trick that you can do. What you really want is to have all the numbers you have to be divided by 100, and then format them to percentage. This is what you do:
Type 100 into a blank cell. Select the cell and do a copy, whether you use the menu, Ctrl - C, the toolbar or one of the other methods. Then select the cells that you want to divide by 100. Then go to the Edit menu and choose Paste Special. A large dialog box will appear. In the Operation section click the Divide option. Then click OK. The numbers you have selected will all be divided by 100. Then format them to percentage. So if you want the number 20 to show as 20%, after dividing it, it will be .2 and then 20% after formatting.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What is the property that allows you to regroup numbers when adding or multiplying the terms without changing the outcome?
Associative Property
Is the property that allows you regroup numbers when adding or multplying the terms without changing the outcome?
Associative property
Why can you break apart numbers to multiply without changing the product?
Because of the distributive property of multiplication over addition.
How can you tell the difference between the associative commutative distributive and the identity properties?
The associative property refers to grouping numbers, which allows you to regroup numbers without changing the answer. 2(1x) = (2x1)xThe commutative property refers to changing the order of numbers without changing the answer. 4+1 = 1+4The distributive property refers to distribution of multiplication over addition. a x (b + c) = a x b + a x c
What number property lets you change the order of numbers in a number sentence without changing the sum?
That's the commutative property.
A telephone company wants to create as many 7-digit phone numbers as possible without changing the first 3 digits How many phone numbers can be created?
10,000
What is the property that states that two or more numbers can be added or multiplied in any order without changing the sum of the product?
Commutative property
The property that states that two or more numbers can be added or multiplied in any order without changing the sum or product?
commutative property
The property that states that two or more numbers can be added or multiplied in any order without changing the sum or the product?
commutative property
What property shows that numbers can be regrouped when being added or multiplied without changing their value?
The commutative property of addition and the commutative property of multiplication.
Does add color to water tell about changing matter without changing its shape?
does add color to water tell about changing matter without changing its shape
Is changing direction really the same as changing speed?
No. It is possible to change direction without changing speed. However, it is not possible to change direction without changing velocity.
