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.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscr...@incubator.apache.org
For additional commands, e-mail: ooo-users-h...@incubator.apache.org
