incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tom Young <>
Subject Re: OO spreadsheet question
Date Wed, 02 May 2012 15:01:26 GMT
On 5/2/2012 10:25 AM, Bill Dillinger wrote:
> When I download my bank statements they come as  .csv  files. When I
> open these in the Open Office spreadsheet the fields with numbers come
> in as characters and the formula window shows them to be preceded by
>  a quote, ', mark. I have looked through 'help' but have not found a way
> to remove the leading quote or to reformat the column to numbers so
> they can be used in calculations.
> I would appreciate it if someone would tell me how to change these 
> columns
> of characters into numbers.
Bill -

I had the same situation and found the answer by looking up "leading 
zeros" in the Help system of OO.  It explains how to replace the " ' " 
with numbers.  Hope this helps.


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message