[libreoffice-users] Re: cannot convert text to number in spreadsheet from csv file

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: 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