Re: Calc: Using scientific numbers

> 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?
>
> Thanks
>
> AG
>