At 14:40 20/11/2007 -0800, Heather 'June Berry' Seaton wrote:
I am trying to enter in ratios in a spreadsheet document, but the
program keeps turning the ratio into a time. How do I stop that from happening?
That depends on exactly what you need.
o If you want to see the fraction as a piece of text (but not
calculate with it), type an apostrophe before the fraction: '2/3
o If you want to enter the value of a fraction, type an equals sign
in front of it: =2/3
o If you want the fraction to appear as such but to be able to
calculate with the value, type a zero and a space in front of it: 0 2/3
In the last case, if you need fractions with multi-digit numerators
or denominators, you may need to set the cell format explicitly to
Fraction and "-1234 10/81". (Go to Format | Cells... | Numbers.)
Also, I can't seem to graph one set of data against another. I need
my time data on my y-axis, and my concentration data on the x-axis.
But it seems to want to graph each as a separate line against "rows".
In the second panel of the Chart Wizard, put a tick by "First column as label".
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
