Re: [libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?
Den tors 3 okt. 2019 kl 01:32 skrev Steve Edmonds < steve.edmo...@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+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?
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,. -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?
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)! -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?
Thanks. No change. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@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