+ Reply to Thread
Results 1 to 3 of 3

Exponential (Scientific) E+ numbers

  1. 02-19-2024, 05:58 AM #1
    pernekde
    pernekde is offline
    Registered User
    Join Date
    03-15-2019
    Location
    sloveni
    MS-Off Ver
    2016
    Posts
    27

    Exponential (Scientific) E+ numbers

    Hello!

    How could I automatically convert the data I have in Column A into the form as it is in Table B?

    Screenshot 2024-02-19 105745.jpg
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-19-2024, 06:11 AM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,731

    Re: Exponential (Scientific) E+ numbers

    That actually changes the value, so you should reduce the exponent by 1, i.e. 11E01, 11E05 etc.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 02-19-2024, 06:30 AM #3
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Exponential (Scientific) E+ numbers

    Change Format Scientific To Number

    atul

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Converting Large (38 digit) Numbers from Scientific Notation to Actual Numbers
    By LilyN in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-08-2023, 01:58 AM
  2. Need use the exponential interpolation of a sequence of numbers to project future numbers
    By adamwes in forum Excel General
    Replies: 3
    Last Post: 08-20-2013, 03:59 AM
  3. Prevent Scientific / Exponential Notation (in CStr) ?
    By expatCanuck in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2012, 05:45 AM
  4. Excel 2007 : Excel Scientific (Exponential) Function
    By sharad.ram1989 in forum Excel General
    Replies: 3
    Last Post: 02-16-2012, 09:53 AM
  5. remove scientific (exponential) notation
    By C12 in forum Excel General
    Replies: 6
    Last Post: 11-18-2010, 12:42 PM
  6. Excel 2007 : stop auto convert of HEX numbers to exponential decimal numbers
    By mayo123 in forum Excel General
    Replies: 2
    Last Post: 04-21-2010, 04:41 PM
  7. change scientific notation (exponential) back to text
    By GEORGIA in forum Excel General
    Replies: 1
    Last Post: 04-06-2006, 11:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1