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?