At 11:02 02/05/2012 -0400, Dan Lewis wrote:
Frustrating isn't it?
Create a column to the right of each column of numbers. (for
example, Column C has numbers in it beginning with cell C3). In cell
D3 enter this formula including =:
=VALUE(C3).
Tap the enter key. Now cell D3 has C3's n
utton.
That should do it.
On 2 May 2012 at 10:25, Bill Dillinger wrote:
Send reply to: ooo-users@incubator.apache.org
Date sent: Wed, 02 May 2012 10:25:54 -0400
From: Bill Dillinger
To: ooo-users@incubator.apache.org
Subject: OO spreadsheet question
> When I download my bank st
Thanks to All! Really quick responses. I have created a new folder in
Thunderbird to save mail from this group as the responses are really
good. Paul's response was first and lead me to an easy answer. My dialog
box had a check for "Quoted field as text". When I unchecked this box
the numbers c
On Wed, 2012-05-02 at 10:25 -0400, 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 hav
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 'he
I believe the dialog box that appears when you attempt to open a .csv file
allows you to specify various characteristics of how the file is
structured. The fields could be tab-delimited or comma-delimited (or any
arbitrary character) and fields may be enclosed in other punctuation that
OOo can stri
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 le