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".
Hi to all,
Many thanks to Heather for helping me with the emailing. The problem was
indeed around not having the extension box crossed. And also the person
who replied to my email account.
Are there any tutorials available that outline how the find and replace
box works, particularly the 'regular expression'?
Kevin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
