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