Re: [libreoffice-users] Re: CALC convert text to numbers

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