[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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
