Re: [libreoffice-users] Re: Excel file in LibreOffice Calc

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 <villeroy@t-online.de> wrote:

From: Andreas Säger <villeroy@t-online.de>
Subject: [libreoffice-users] Re: Excel file in LibreOffice Calc
To: users@global.libreoffice.org
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: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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