M. Fioretti wrote > Summarizing, it seems I need some efficient way to tell Calc, when it > opens that file, that all the cells of a certain column, except the > header, are NUMBERS, not text, in the -1234.12 format.
What Mirosław Zalewski has suggested upthread is essentially correct. The data formats must match the language used (usually the locale) on import. The solutions are to either: (a) edit the data to contain data formats used in the expected language; (b) change the expected language on the Text Import dialogue to match the used data formats. For a numeric format of -100.25 try selecting a Language of "English (US)" or equivalent on the Text Import dialog. Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/cannot-convert-text-to-number-in-spreadsheet-from-csv-file-tp4105787p4105808.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] 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
