Hi :) It is possible to change types of columns, rows, other selected areas or even individual cells. Select area or whatever and then Format - Cells - Numbers Then in the left-hand box select which data-type is most relevant. Regards from Tom :)
--- On Thu, 22/9/11, Andreas Säger <[email protected]> wrote: From: Andreas Säger <[email protected]> Subject: [libreoffice-users] Re: Excel file in LibreOffice Calc To: [email protected] Date: Thursday, 22 September, 2011, 7:04 Hi, It has nothing to do with formatting. It is all about data types. The leading apostrophe tags numeric expressions and formula expressions as literal text. This is _exactly_ the same in Lotus 1-2-3, in all versions of Excel and in Gnumeric. You are responsible for the data types. You have to enter/import/paste data as numbers or as text. If you import everything as text, the application treats it as text. -- For unsubscribe instructions 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 -- For unsubscribe instructions 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
