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