2016-05-11 21:43 GMT+02:00 shirish शिरीष <shirisha...@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+unsubscr...@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