Re: [libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?

Den tors 3 okt. 2019 kl 01:32 skrev Steve Edmonds <
steve.edmonds@ptglobal.com>:

> On 03/10/2019 11:55, Gilles wrote:
> > Johnny Rosenberg wrote
> > > If your cell was formatted as text, then whatever you type into that
> cell
> > > will be displayed as pure text. The funny thing is that changing the
> > > format doesn't help. You must first empty the cell, then format it as a
> > > number, then type your formula again. You can also first format the cell
> > > to a number format, then empty it and
> > > finally enter your formula again.
> > Makes sense. Thank you (and to someone off-band)!
> You do not even need to empty the cell, after making sure the cell is
> formatted number just edit the formula [like remove the last ) and
> retype it] and then press enter. =SUM(B4:B8) > =SUM(B4:B8 > =SUM(B4:B8)
> and enter. Just out of interest, there is no difference in the number of
> actions required,.

Oh, that's good to know. I didn't try that. Thanks!


Johnny Rosenberg


> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy