> > 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.