On 11/12/2007, Joe Smith <[EMAIL PROTECTED]> wrote: > > Pierre wrote: > > ... > > Is there a quick way to convert the text values back to numeric ones? > > A Find & Replace triggers a re-interpretation of the values, so > > Search for: .* > Replace with: & > Options / Regular expressions: YES > > Will also convert all the numeric strings to the actual numeric values. > > <Joe
That's very neat. But I think it's a [quite serious] bug. What if the "numbers" were telephone numbers, ISBN numbers, Dewey Decimal numbers or other numerical data which you had entered as text in order to preserve leading zeros, "dot" separators etc.? Seems to me that Find & Replace has no business messing up my carefully considered data formats. -- Harold Fuchs London, England Please reply *only* to [email protected]
