TerryJ wrote:
Harold Fuchs-2 wrote:
[EMAIL PROTECTED] wrote:
openoffice2
In calc, I have values that open is reading as text, ie '670, I need to
change these to actual numeric values so I can total them etc.
How do I do this.
thanks, B Nock.
Assuming you have the text values in column A, rows 1 to 10 inclusive
("1 thru 10" if you are American), then set B1 =VALUE(A1), where "VALUE"
is the name of one of Calc's functions. Then drag B1 to B2, B3 etc. down
to B10 and finally set B11 = SUM(B1:B10).
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
If the only thing you have to do is remove the leading apostrophe, use
search and replace. On Windows, I believe you search for ^' and replace
with nothing. You have to press "More Options" and select "Regular
Expressions".
a) Copying unregistered OP.
b) I assumed the OP would not want to destroy the original data.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
