Re: Excel & CSV files with long strings of digits

[Philip Newton]

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?

Cheers,
--
Philip Newton <philip.new...@gmail.com>