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".
--
View this message in context:
http://www.nabble.com/how-do-I-convert-a-text-number-to-a-numeric-number-tf3409614.html#a9506786
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
