[SOLVED] Conver Numbers to Log 10

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

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 <0CDE6301-FC9C-488C-9D9F-3AD26B46EFCE@microsoft.com>,
"Fishfan" <Fishfan@discussions.microsoft.com> wrote:

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