+ Reply to Thread
Results 1 to 4 of 4

Formatting an Exponential Number

  1. #1
    Registered User
    Join Date
    06-29-2008
    Location
    Tyler, TX
    Posts
    39

    Question Formatting an Exponential Number

    Greetings-

    How can I format -6.102E-08 to look like 6.102x10-8?

    Thank you for your time.



    -Bryan

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: Formatting an Exponential Number

    It will not happen through formatting. Off the top of my head, you will have to convert your number to a text string with the appropriate elements. A formula like: =CONCATENATE("-6.102","x","10-8") or =SUBSTITUTE(TEXT(value,"0.000E+0"),"E","x10"). Then, in order to superscript the exponent, you will need to copy and paste as values to get the text literal, then you can format the exponent part of the text string as superscript.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    06-29-2008
    Location
    Tyler, TX
    Posts
    39

    Re: Formatting an Exponential Number

    Quote Originally Posted by MrShorty View Post
    Then, in order to superscript the exponent, you will need to copy and paste as values to get the text literal, then you can format the exponent part of the text string as superscript.
    So, if I do this in the manner described above, will the value be able to be changed based on the data input?

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: Formatting an Exponential Number

    No. In order to get the exponent superscripted, you have to convert the result of the formula to a text literal/constant, which means that it cannot continue to be the result of a formula. When you want to do something like this, you have to decide if you want the exponent superscripted, or if you want the cell to be the result of a formula (or you can come up with VBA/Macro code associated with the calculate event that will take the text formula result and write the result into the cell as a text literal and apply the appropriate formatting to the exponent characters).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 02-12-2015, 01:52 AM
  2. Conditional Formatting quirk with Number formatting
    By ChemistB in forum Excel General
    Replies: 9
    Last Post: 07-20-2011, 08:44 AM
  3. Exponential Formatting
    By TBeverson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2009, 03:27 PM
  4. Replies: 3
    Last Post: 02-12-2009, 01:08 PM
  5. Exponential Number to Text
    By RichHartmann in forum Excel General
    Replies: 1
    Last Post: 11-08-2006, 05:38 PM
  6. alpha field getting turned into an exponential number
    By dkellison in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2006, 03:10 AM
  7. [SOLVED] alpha field getting turned into an exponential number
    By dkellison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2006, 01:30 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1