Dan Lewis wrote:
>
> On Thursday March 15 2007 7:59 pm, 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".
>
> Did you try this? I just did, and it did not work. (^' in the
> Find box and the Replace box empty with Regular Expressions
> selected.)
> What does work is place ".*" in the Find box and "&" in the
> Replace box (without the quotes). Select Regular Expressions. Then
> click the Replace All button. I found this in NoOP's reply to you
> back on Feb. 28, 07. Re:Removing formatting marks from Calc cells.
>
> Dan
>
>
Evidently, it is only in Linux (or should I say, not in Windows?) that you
need to search for .* One subscriber mentioned that simply searching for
the point works. Another user (on the forum) searches for .+ These are all
workarounds required because search on Linux (?et al?) cannot find a leading
apostrophe - it will find and replace the same character elsewhere in a
string. The workaround/s is/are now being touted as a feature.
--
View this message in context:
http://www.nabble.com/how-do-I-convert-a-text-number-to-a-numeric-number-tf3409614.html#a9509581
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
