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

Reply via email to