I got this far but for some strange reason
I cannot display the formula in a cell.
All I get are the results of the formula.
How do I see the hidden formulas that gave these results?

Of course I can retype the formulas because I know
what they are. I don't want to do that over and over.
I can copy then with relative addressing if I could get
them to appear.

Seems life would be a lot simpler if cells had two sections.
One section to hold the formula and the other to hold
the results of the formula instead of hiding the formula
in the same cell.

Paul Lamar ...No rotor no motor.


Paul,

In the Excel world, formulas are entered into a cell with o preceding "="
equals sign.  Without the "=", the application thinks you are just entering
the value that results from the mathematical expression you are using.

I'm not an Open Office user, so I hope I have not added confusion.

Grant

That is the same in Open Office. I am beyond that.
Once I calculate the sheet I can't see the formulas to copy
them below the next set of data. For some strange reason it
worked in the original sheet. Then I saved it and I reloaded
it. Perhaps that has something to do with it.

Paul Lamar ...No rotor no motor.

The Rotary Engine NewsLetter. Powered by Linux.
ACRE NL web site. http://www.rotaryeng.net
Copyright 1998-2005 All world wide rights reserved.

Paul,

Please send me the sheet you are having this problem with.  I've been
trying to figure out how to change the results of a formula to an
actual value.  That makes it easier to copy some calculated data to
another spreadsheet for example.  Maybe you've found a way to do it.

Bob W.