Hello, I can only speak for myself, but numbers get formatted as text in two ways:
1. Import of a tab delimited or csv file. 2. Spreadsheets sent to me from other users who have imported such files. Usually I format the import to avoid the problem, but if I just double click a csv file, it opens with the numbers formatted as text. Visually this is not a problem. But if I then decide I need to edit the sheet I either have to reimport it or reformat the numbers. Hope this explains how it happens to me. Charles Sent from my iPod Touch On Nov 17, 2013, at 12:16 PM, James E Lang <jim+...@lang.hm> wrote: > I've been following this debate with great interest. > > One big question comes to mind: Why would someone use the apostrophe > construct in the first place if he intended to perform arithmetic > calculations using the cell content? I understand ending up with a text > string rather than a number by forgetting to use VALUE() on a substring in a > formula but even that seems to fall into the category of a "cockpit error" > rather than an "aircraft design flaw" as is being implied on one side of this > debate. > > > > -- > Jim > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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