exponential issue

  1. P

    LN and exp function on big numbers in excel, a bit mathematical question maybe

    Dearest helping hand, I have been wondering for almost a day now how to handle the following problem (which might also be a bit mathematic). In column A i have 100.000 numbers and each of them is very big, around 9.000.000. I need to calculate the following: LN(...
  2. M

    Internet and Excel Exponential download problem

    I daily download a file from a client’s web site, one of the fields that I download is read into Excel as numbers, and when this number is very large the number appears in Excel as Exponential. Example When this ID is downloaded it appears like this “6.00107E+11” <?xml:namespace prefix = o ns =...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top