Conver Numbers to Log 10

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to conver the number "10" to spell "Ten" 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Counting with Date Range as Criteria 5
How do number columns first, then the rows in an excel footer? 1
Average of numbers under 10 6
Easy Reading - large number minus small number 5
Convert numbers stored as text to numbers - Automatically - Macro 2
Excel Subtracting multiple columns from another column 3

Back
Top