Converting columns of data other values

G

Guest

Guest
I recently posted a question about converting whole columns of data to other values and got an answer that only can do it one value at a time. I am new to excel and need to change large columns of data to there Ln value and do not what to do this one value at a time. Isn't there a way to convert large columns of data? Say you accidently entered a large amount of data with the wrong decimal point and that to corrrect that error all that needed to be done is multiply the entire column of data by 10. It this possible? I have to find the Ln of numerous columns of data in a number of files and this would be the best approach to the problem. Thanks.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
To multiply a column of data by 10:

1. In an empty cell, enter 10.
2. With this cell selected, select EDIT - COPY.
3. Select the entire column of data.
4. Select EDIT - PASTE SPECIAL.
5. Under the Operation section, select MULTIPLY.
6. Click OK.

The entire column will be multiplied by 10.
 
Upvote 0
On 2002-02-27 07:47, Anonymous wrote:
To multiply a column of data by 10:

1. In an empty cell, enter 10.
2. With this cell selected, select EDIT - COPY.
3. Select the entire column of data.
4. Select EDIT - PASTE SPECIAL.
5. Under the Operation section, select MULTIPLY.
6. Click OK.

The entire column will be multiplied by 10.

But that's not what the OP is asking, which is applying LN to each cell in a column.
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,938
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top