ExcelBanter - Conver Numbers to Log 10

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Conver Numbers to Log 10 (https://www.excelbanter.com/new-users-excel/25526-conver-numbers-log-10-a.html)

Fishfan

Conver Numbers to Log 10

How do I convert column of numbers (n=3000) to log 10 column of numbers?

JE McGimpsey

Assuming that your column is column A, one way:

In an unused column, enter

=LOG(A1)

and copy down 3000 cells.

Copy the column, choose column A and choose Edit/Paste Special,
selecting the Values radio button.

In article ,
"Fishfan" wrote:

How do I convert column of numbers (n=3000) to log 10 column of numbers?

All times are GMT +1. The time now is 07:40 PM.