Conver Numbers to Log 10

How do I convert  column of numbers (n=3000) to log 10 column of numbers?
0
Fishfan (1)
5/10/2005 3:09:02 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
620 Views

Similar Articles

[PageSpeed] 16

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?
0
jemcgimpsey (6723)
5/10/2005 3:20:43 PM
Reply:

Similar Artilces:

logging into MeetingPlace
I cannot log into Meeting Place. I get a login screen, but when I put my login and password it won't accept it. ...

Log Scale Units
Good afternoon. I would like to modify the y-axis units (in log) from 10, 100, 1000 to (for example) 7, 70, 7000. Is this possible? Thanks! Not in Excel 2003. I believe that the options in Excel 2007 may be different, but whether that is possible I don't know. -- David Biddulph RussG wrote: > Good afternoon. I would like to modify the y-axis units (in log) from > 10, 100, 1000 to (for example) 7, 70, 7000. Is this possible? Thanks! RussG You can make a custom axis that will give you what you want. Here's a link to a how to http://processtrends.com/pg_charts_custom_axis....

Upgrading GP 10
Is there a way to create an installation package for client delpoy that will install the GP 10 prerequisites, install GP 10, install the GP service pack, upgrade 3rd party applications (need to uninstall existing version, install version 10), one after the other? If possible this could be deployed from Active Directory. To satisfy your needs, let’s divide them into points: 1. Install the GP 10 prerequisites The installation already installs the prerequisites upon launching the package. 2. Install the GP service pack Checkout blog post below on how to include the Service Packs inside th...

Using Numbers for Tickets
Hello I am attempting to run a fund raiser and need to number tickets using Publisher.I need to have a number on the stub, correspond and be the same number on the buyer's ticket. Is there a way I can place a number in the ticket and on the stub for the same ticket and have it number each as 1 to 1, and then on in sequence 2 and 2 etc? Thanks for any help given on this matter -- Thank You Coach Cone Create a data base with the numbers Example here: Consecutive Numbering (2002, 2003) http://www.publishermvps.com/Default.aspx?tabid=95 Open the Catalog and Mail merge wizard, browse to ...

Generate random number
Hi all How can I create a method that returns me a random number between 1 and 20 (extreme included)? Thanks in advance. Luigi "Luigi" <Luigi@discussions.microsoft.com> wrote in message news:DF4C43E2-7D9C-483F-A6DB-7B0B3B0BB3C3@microsoft.com... > Hi all > How can I create a method that returns me a random number between 1 and 20 > (extreme included)? > > Thanks in advance. Random rand = new Random(); int num = rand.Next(1,20); Dubravko * Luigi wrote, On 15-1-2010 10:28: > Hi all > How can I create a method that returns...

Count number of times a text occurs
I want to count the number of times a text occurs in a range and then put 1,2,3,ect in a cell adjacent to the occurance. Apple 1 Apple 2 Apple 3 Apple 4 Banana 1 Banana 2 Banana 3 I can use the count function but it doesn't seem to help with the numbering. It seems like it should be simple but it probably isn't. Thanks for any help. -- Lee Try this, copied down =COUNTIF($H$2:H2,H2) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Lee" <lee@nospam.jjlgreenhouses.com> wrote in message news:%239S0dY8KJHA.4292@TK2MSFTNGP03.phx.gbl......

Get highlighted numbers to SUM instead of NUM @bottom of screen?
When you highlight a column of numbers the bottome of the screen shows the number of cells highlighted. How do I change it to show the SUM of the highlighted cells? Hi You need to right-click on that number and a list of otions will appear, including SUM, AVERAGE etc. Andy. "jimbo" <jimbo@discussions.microsoft.com> wrote in message news:B13BEE0A-1A22-4029-A823-6865BDB967AA@microsoft.com... > When you highlight a column of numbers the bottome of the screen shows the > number of cells highlighted. How do I change it to show the SUM of the > highlighted cells? ...

sending email 03-17-10
an email sending is blocked because of a wrong email so how do you get this email canceled. Open the Outbox folder. Delete any messages you see there. --=20 Gary VanderMolen, Microsoft MVP (Mail) Microsoft MVP Program: http://mvp.support.microsoft.com "horseradice07netherlands" = <horseradice07netherlands@discussions.microsoft.com> wrote in message = news:15BF2E99-9156-45F4-8197-A9F639886059@microsoft.com... > an email sending is blocked because of a wrong email so how do you get = this=20 > email canceled. ...

Displaying a number from another column
Hi, Need some help: Let's say I have a list of numbers in column A: A1:1 A2:2 A3:3 An:n And another list of random numbers in column B: B1: 2.3 B2: 3.5 B3: 55.6 Bn: <some random number> If I enter a number in cell C1=An, how do I make cell D1 display the corresponding B column value? Eg: If in C1, I enter "2", how do I make D1 show "55.6" Thanks! Enter this in D1: =VLOOKUP(C1,A1:Bn,2,0) Change Bn to suit your range. If you have no value in C1 or if the value is not part of your list, you will get the error message #N/A. Hope this helps. Pete Natalie...

RMS should be able to handle multiple serial numbers easier.
When you have to enter many serial numbers , either to take itmes into stock , transfer stock from store to store or even sell, it is not very fast . I think simply if when you scan a serial the code just places a tab or enter so the cursor will automatically move to the next line . In this way the scanning process will be much much faster . ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this ...

Number not showing correctly
Hi, I had tried to enter a 12digit number in a worksheet but after entering it its not showing the coorrect number.Eg Iam trying to enter 857268578633 in the work sheet but after entering its showing 8.57269e+11 Why its happened Like this can you please explain me the format of the cell is probably 'General' instead of number. When you select number you can select the number of decimal places and/or the comma and negative number format if you like. If it then shows up as ###### or still has the scientific format appearance, you can widen the column. "Nawas" wrote: ...

how to drag the cell to assign numbers by skipping one row each ti
1 skip 2 skip 3 skip 4 and so on... I A1 enter 1 In A3 enter 2 Select A1:A4 and drag down. -- Regards Dave Hawley www.ozgrid.com "Paran" <Paran@discussions.microsoft.com> wrote in message news:8633F6F5-AF19-492D-9163-8735373A222A@microsoft.com... > 1 > skip > 2 > skip > 3 > skip > 4 > and so on... hi in a1, enter 1 in a3, enter 2 in a5, enter 3 in a7, enter 4 this will leave a2,a4 and a6 blank. high light a2:A7. DO NOT include a1 in the high lighted selection. hover the mouse over the lower left corner of ...

new to outlook #10
I'm migrating from OE to Outlook 2007 and having issues with views. Is there a way to setup your views/screen and save it as a style or similar? Assuming I can save the style can I pass it to other users and get their screens to look the same? thanks you can create custom views - sharing them with other users is hard, especially if you don't use exchange. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Outlook Tips by email: mailto:dailytips-subscribe-request@lists.outlooktips.net EM...

burning a CD 01-07-10
I have Windows XP Home Edition and im trying to use my Windows Media Player to burn one of my play lists onto CD however sum of the songs have been ripped from CDs and others have been downloaded and they're MP3 types and it says can not synchronize?? How am i able to get those songs onto my audio CD? Thanks in advance :D What's the exact text of the error... ? That seems like a strange response from the player, so I'm wondering what the specific text is. When you click Web Help on the error dialog, what URL does it take you to? -- Speaking for myself only...

eConnect 10.0
Problem: Transaction requester does not have any available document types to enable. Background: We just completed out eConnect 10.0 installation. The software is installed on the same system that hosts GP & its SQL server. The OS is SBS 2003 (fully updated.) MSMQ has 4 of its 6 Subcomponents installed (AD Integration, Common, MSMQ HTTP, & Triggers) The not installed subcompontents are (Downlevel Client Support, Routing Support) Does anyone have any idea why we have no available document types for insert/update/delete/Message Queues? Further details: The eConnect_Out_Set...

numbering #2
Using Pub. 2000. I want to set a listing of calender dates vertically. 1/tab/topic/enter, 8/tab/topic/enter and so on in a vertical flush left format. The number tool tab keeps popping up and wants to put in the next number in sequence, as 1, 2, 3, 4, I want to use different numbered dates when I go to a next line. How do I stop this from happening constantly. Thanks for your help. Tools, AutoCorrect Options, AutoFormat as you type tab... -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.mvps.org/msauer/ news://msnews.microsoft.com "Harvey" <anonymous@dis...

Upgrade OSX 10.4.6 can no longer save or open files.
I recently upgraded to 10.4.6 on my mac and now office 2004 (Word) cannot save any documents I make. It imediatly crashes. Same when I attempt to open a word doc using the pull down menue in Word, this causes the program to crash. I have re-installed office 2004 several times and it has not made a difference. Any suggestions? 78homersimpson78 wrote: > I have re-installed office 2004 several > times and it has not made a difference. Any suggestions? The first thing is to be sure that you ran Office's "uninstall" application before reinstalling, rather than just dele...

Find which numbers sum up to given total
I have been presented with 13 numbers and given a total for the sum of 5 of these numbers. Will excel allow me to find which 5 of the given numbers add up to my known total. Sub add_perm() Dim i As Integer Dim j As Integer Dim k As Integer Dim m As Integer Dim n As Integer Dim p As Integer Dim NN As Integer Dim SS As Integer Range("destination").ClearContents SS = Range("known_total") NN = Range("numbers") - 1 '13-1 p = 1 For i = 0 To NN For j = 0 To NN For k = 0 To NN For m = 0 To NN For n = 0 To NN ...

GP 10 Slow
We just switched to version 10, and it's very slow to open, slow to bring up a company, and slow to close. Is there any way to speed things up? Mary Fetsch It is slower than 9 but should not be VERY slow. How much memory do you have on the workstations? You must have 1G but I recommend 2G. -- Richard L. Whaley Author / Consultant / MVP 2006-2008 Documentation for Software Users Get our Free Tips and Tricks Newsletter and check out our books at http://www.AccoladePublications.com "Mary Fetsch" wrote: > We just switched to version 10, and it's very slow to ope...

formula help 02-17-10
Hi i got this formula =INDEX($A$13:$BD$1000,MATCH($C$13,$A$13:$A$1000,0),MATCH(D2,$A$11:$BZ$11,0)) i want to use the same formual but this time to match more than cell. thanks Your index/match formula will return one intersection point, ie the value where the row match & column match intersects. Maybe try re-explaining with a small-sized sample data (what you have), and what you want to happen, take us through your logic, show us the expected results based on that sample data. -- Max Singapore --- "Rohit" wrote: > i got this formula > > =IN...

total memory available is only 3.3GB with 4GB physical memory under windows 7 64 bit 05-16-10
I had 4GB physical memoryon the PC. With Windows vista 32 bit, available memory is shown as 3.3GB. I asked on usenet and was told that only under 64 bit windows, will the available memory be 4GB. When I upgraded to windows 7, I chosed 64 bit (I did clean install of course), but the available memory shown in the system is still 3.3 GB. This is show in both task manager under performance->Physical memory->total, and 'property of My Computer'->Installed memory (4GB/3.3 GB usable) Why is this and is there a way to make the full 4GB available? It's possible th...

How to limit the number of accepted meeting requests
Is there a way to limit the number of accepted meeting requests when sending out a meeting request? "triumph615" <triumph615@discussions.microsoft.com> wrote in message news:3182F693-BA81-4BC2-BDB3-FB751769C46A@microsoft.com... > Is there a way to limit the number of accepted meeting requests when sending > out a meeting request? No, not with plain Outlook. -- Brian Tillman [MVP-Outlook] ...

Best way to find row number of last row containing data
I would like to know the best way of find the row number of the last row containg data in a worksheet. Searching through newsgroups and web sites I found the first option (which is commented out below) but this is column specific i.e. it only works if the last used cell in the worksheet is in column A. My latest effort is the LROW line without the comment - but is this the best or does anyone know a better or more efficient way? Function LROW() As Long ' Returns the row number of the last row containing a non-blank entry in a worksheet Application.Volatile ' LROW = Range...

setting up of 10 seconds to open email
Hi Can anybody tell me, whether setting up of 10 seconds time to open the email when arrived(with or without attachment) in Inbox of Outlook express helps to save the virus threat? as within this 10 seconds the message can just be viewed, and deleted immidiately, if it is suspicious without waiting to 'envelop' to open and mark as read. Does this helps in avoiding further consiquences that might occur if the email is opened? Shanks No, it's just an envelope changing after x seconds. Note that in both Outlook and Outlook Express automatic execution of attachments is not ...

Time zone issue with calendar invites sent to iCal users 03-15-10
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Email Client: Exchange We're using Entourage 2008 (latest patch) in conjunction with Exchange 2003. We're on the West Coast in the U.S. When we send calendar <br> invites to one of our employees in Zurich who uses iCal, they always show the wrong time, e.g., an invitation for 9am PST will show up in <br> his calendar at 9am Zurich time rather than being automatically adjusted for the time difference. <br><br>I've seen postings about this issue but have not seen a resolution. Any...