Re: I'm sure it's very simple!

2013-03-04 Thread Brian and Nancy Street
Hi Brian OMG... thank you... However that got turned on... I have NO idea... but I finally got into the calc mode, and unticked the Formula box...AND hit OK... and everything seems to be working now... A million thank you's, I truly thought I was going mad. Have a fine day. Here is howe it

Re: I'm sure it's very simple!

2013-03-04 Thread Brian and Nancy Street
Hi Brian, I appreciate your help... BUT... when I go under preferences... this is the dialogue box that come up. I can't find the box with "formulas" to Un-tick. BUT I do feel we are getting closer to the problem. I really have been searching. Any other thoughts as to where this formulas box ma

Re: I'm sure it's very simple!

2013-03-04 Thread Brian and Nancy Street
Hello Brian, Thank you for your e-mail. When I go to Tools... there is not an OPTIONS heading?? It starts off as Spelling, Language, goal seek, solver... where would the options be? I have searched all of the drop downs from the menu and no luck. I have entered the formula correctly... I've

Re: I'm sure it's very simple!

2013-03-04 Thread Brian Barker
At 08:55 04/03/2013 -0800, Brian and Nancy Street wrote: ... BUT... when I go under preferences... this is the dialogue box that come up. I can't find the box with "formulas" to Un-tick. BUT I do feel we are getting closer to the problem. I really have been searching. Any other thoughts as to

Re: I'm sure it's very simple!

2013-03-04 Thread Brian Barker
At 06:46 04/03/2013 -0800, Nancy Street wrote: When I go to Tools... there is not an OPTIONS heading? It starts off as Spelling, Language, goal seek, solver... where would the options be? Usually at the bottom of that menu, but it's absent in one circumstance. Read on. I have entered the fo

Re: I'm sure it's very simple!

2013-03-03 Thread Brian Barker
At 11:00 03/03/2013 -0800, Nancy Street wrote: Hello, I would appreciate your help and I'm sure the answer is very simple...but I've been searching for a day and a half...trying to google, and FAQ.. to no avail. QUESTION: In a spreadsheet, Rather than displaying the ANSWER... the cell will onl

Re: I'm sure it's very simple!

2013-03-03 Thread Martin Groenescheij
Go to Tools --> Options --> OpenOffice.org Calc --> View and deselect Display Formulas On 4/03/2013 6:00 AM, Brian and Nancy Street wrote: Hello, I would appreciate your help and I'm sure the answer is very simple...but I've been searching for a day and a half...trying to google, and FAQ.. to