openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Groenescheij <Mar...@Groenescheij.COM>
Subject Re: Spread Sheets issues.URGENT HELP PLEASE
Date Tue, 08 Jul 2014 16:23:56 GMT

Select cell A111 and if it shows a *`* in the formula bar before the 
value it is defined as text.
Just delete the ` and it should give you the correct results.

On 9-7-2014 2:12, Andrea Madott wrote:
> I'm having problems with my spread sheet.   I highlight a row to sum and it
> adds everything but the first line.  I tally each months expenses into a
> total and then use that total as the basis of next month's opening balance
> but Open Office is not allowing that.  If I highlight and auto sum lines
> 110 to 123, the formula shown in the total cell reads =SUM (A111:123) and
> ignores the first cell.  Please help, just converted to open office and now
> all my accounting is wrong.
>
> Regards,
>
> *Andrea Madott*
> *Sales Representative*
>
> *Helping you is what we do*
>
> *Royal LePage Gale Real Estate, Brokerage*
> *105-383 Parkdale Avenue, Ottawa, ON K1Y 4R4*
> *(613) 723-5300 <%28613%29%20723-5300> office (613) 614-5433
> <%28613%29%20614-5433> direct*
>
> *"**Oh by the way, I'm never too busy for your referrals" *
>
>   Follow me on Twitter! https://twitter.com/@Andreamadott
>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message