On Thu, 09 Jul 2009 10:20:37 +0100 Came this utterance formulated by AG to my mailbox:
> AG wrote: > > Harold Fuchs wrote: > >> 2009/7/9 AG <[email protected]> > >> > >> > >>> Hello > >>> > >>> I am using scientific notation in a spreadsheet, but want to round > >the data>> off to a common exponent. > >>> > >>> At present I have data such as: > >>> > >>> 6.8E+15 > >>> 1.15E+21 > >>> 5.09E+19 > >>> > >>> and so on. > >>> > >>> I want to do a graph, but at present the columns are very out of > >proportion>> because of the data with 21 as an exponent. I therefore > >wanted to change>> this to ^19 which about the most frequently > >occurring exponent in my data>> set. How do I do this? At the > >moment, whenever I try, Cacl very helpfully>> (or not!!) > >automatically changes 115E+19 back to 1.15E+21 and so on. I>> > >obviously cannot change this to text in terms of the formatting > >otherwise it>> seems as if the chart won't pick it up for display. > >So how do I get around>> this? > >>> My method would have been to divide all the results by 1E19 into another column, force this column to use standard notation, then mark the graph as(E+19) in the Axis Label. Using E18 as a multiple of three may be a more acceptable alternative to some. 1E18 = 1,000,000,000,000,000,000 = 1 quintillion or 1 exa(unit) using SI. Example: the age of the universe is 0.4 exaseconds give or take a lifetime or two million. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
