| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel how do I increase the amount in an entire column by a %?
I need to increase all the numbers in a column by 10%. Can anyone help me?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel how do I increase the amount in an entire column by a %?
If your original number was in A1 you could use the formula below.
=A1*1.1 "Brittany" wrote: I need to increase all the numbers in a column by 10%. Can anyone help me? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel how do I increase the amount in an entire column by a
type 1.1 in on cell, copy it and paste special as multiply
HTH Regards from Brazil Marcelo "tim m" escreveu: If your original number was in A1 you could use the formula below. =A1*1.1 "Brittany" wrote: I need to increase all the numbers in a column by 10%. Can anyone help me? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel how do I increase the amount in an entire column by a %?
in a cell somewhere put 1.1
copy that cell select your range editpastemultiply -- Don Guillett SalesAid Software "Brittany" wrote in message ... I need to increase all the numbers in a column by 10%. Can anyone help me? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel how do I increase the amount in an entire column by a %?
In some empty cell, enter the number 1.1. Copy (ctrl+c) that cell. Then
select your column of numbers and Edit Paste Special. Select VALUES and MULTIPLY then click OK. "Brittany" wrote: I need to increase all the numbers in a column by 10%. Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| How do I increase a column of numbers by a percentage-same cell | Excel Discussion (Misc queries) | |||
| Copy one cell to entire column | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Hybrid Mode
