Results 1 to 6 of 6

Scientific format

Threaded View

ElmerS Scientific format 07-18-2010, 07:52 AM
pike Re: Scientific format 07-18-2010, 08:05 AM
ElmerS Re: Scientific format 07-18-2010, 08:21 AM
shg Re: Scientific format 07-18-2010, 10:38 AM
ElmerS Re: Scientific format 07-18-2010, 02:35 PM
shg Re: Scientific format 07-18-2010, 02:56 PM
  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Scientific format

    Hi,

    Is there a way to force Excel to display the Scientific format of large numbers when the power-digit can be divided only into 5 - such as: E+05, E+10, E-15 and the number itself will be adjusted accordingly.

    1.23E+07 will be either: 123E+05 or: 0.00123E+10

    What I basically mean is that the: 0.00E+00 will be one of the following:

    0.00E+05
    0.00E+10
    0.00E+15
    0.00E-05 etc...

    Thanks, Elm
    Last edited by ElmerS; 07-18-2010 at 02:36 PM.

Thread Information

Users Browsing this Thread

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

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