On Fri, Jun 01, 2007 at 11:50:18AM +0000, H.Merijn Brand wrote: > On Fri, 1 Jun 2007 13:44:08 +0200, Anton Berezin <to...@tobez.org> wrote: > > > On Fri, Jun 01, 2007 at 01:24:12PM +0200, Philip Newton wrote: > > > On 6/1/07, Anton Berezin <to...@tobez.org> 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)
That fits my definition perfectly. \Anton. -- We're going for 'working' here. 'clean' is for people with skills... -- Flemming Jacobsen