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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
