Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

2016-05-11 21:43 GMT+02:00 shirish शिरीष <shirishag75@gmail.com>:

> Now non-plussed how to tell libreoffice to tell it to treat them as
> 'real numbers' ?

​Short answer: it should work :)

If a cell is somehow stuck in the "text" type, you could try clearing all
formatting on this cell (defaults to Ctrl-M), or select the affected cells,
do right-click/properties, then select an appropriate number format.
However, LibreOffice should recognize number automatically unless
explicitely instructed to treat them as text; this can happen from weird
copy/paste, when opening files in exotic formats, or by doing it by hand.
It is also possible (although we didn't see a sample file) that there are
extra characters in the cells, or maybe an invalid decimal separator for
the file's locale.

​If you could upload a sample somewhere, we might get a better look at it
:)​

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted