Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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+lou@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+unsubscribe@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+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.