On Fri, 1 Jun 2007 13:44:08 +0200, Anton Berezin <[email protected]> wrote:
> On Fri, Jun 01, 2007 at 01:24:12PM +0200, Philip Newton wrote: > > On 6/1/07, Anton Berezin <[email protected]> wrote: > > >I experimented a bit, and > > > > > >1234567890123456 > > > 1234567890123456 > > >"1234567890123456" > > > > > >are all silently and without complaint converted to a floating point > > >number. > > > > > >'1234567890123456' gets converted to '1234567890123456', which is better, > > >but only slightly. > > > > Did you try > > > > '1234567890123456 > > > > with a leading but no trailing quotation mark? > > Yup - it would work if I were to generate an Excel file directly. In CSV > conversion, one just gets '1234567890123456 verbatim, as it was. > > The converter is hatefully cleverer than you or me. Define 'clever'. M$ Excel has always managed to make me curse when using it's convertor(s) and `do-the-right-thing'. So far their cleverness has managed to *never* do the-right-thing (TM) > \Anton. -- H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/) using & porting perl 5.6.2, 5.8.x, 5.9.x on HP-UX 10.20, 11.00, 11.11, & 11.23, SuSE 10.0 & 10.2, AIX 4.3 & 5.2, and Cygwin. http://qa.perl.org http://mirrors.develooper.com/hpux/ http://www.test-smoke.org http://www.goldmark.org/jeff/stupid-disclaimers/
